|
|
|
|
|
Unicode support is available if your MS Access file is in Access 2000 format or later.
MS Access supports Unicode data in all character data types. No special configuration is needed for this.
To use unicode data in a PostgreSQL database, you must create the database with a unicode character set. An example:
createdb -E UNICODE dbname
However, beyond this we have been unable to store or retrieve Unicode data from a PostgreSQL database (using PostgreSQL v7.3.4). The Unicode database needs to be compiled with multi-byte support enabled - perhaps the build we are running does not have this. Any feedback on this would be helpful.
While this database supports Unicode data, we have been unable to get this to work with AQT. It could be that the ODBC Driver does not support Unicode. There are some third-party ODBC Drivers that claim Unicode support, however we have not investigated these. Any feedback on this would be helpful.