Hello,
Our Intersystems Cache database is running in a Windows 2008 R2, and is installed and configured as "UNICODE" .
We are using Apache+PHP with ODBC to get data but we have some problems with character encoding.
We also have two configurations:
- Ubuntu 16.04 LTS + Apache2 + PHP 5.6 + UnixODBC
- using isql command everything works fine, data returned is OK (all special characters in Spanish displayed ok).
- using PHP with PDO function to connect the database and libcacheodbcu35.so driver
- with default_charset="" in php.ini
- Special characters in spanish not displaying ( like ü , é , ó , à , .
