Previous Topic

Next Topic

Book Contents

Book Index

Unicode support with other databases

MS Access

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.

PostgreSQL

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.

Interbase / Firebird

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.

Advanced Query Tool
https://www.querytool.com
© 2023 Cardett Associates Ltd. All rights reserved.