Informix

Create an Informix UTF8 database

1. Make sure the server SQL_LOGICAL_CHAR in server configuration file is set to 3 or 4 bytes. Example SQL_LOGICAL_CHAR 4
2. On command line, set enviornmont variable DB_LOCALE
   set DB_LOCALE=en_US.utf8
3. Use dbaccess to create the database.

Add Windows User to Database

1. Optional, add Windows user to Informix-Admin Windows group if user is to have server Admin privileges.
2. Login to the database as user informix and grant the Windows user appropriate role(s). Example:
   grant dba to user55
3. For an ANSI database, enter Windows user name in upper case when entering login ID for the database ODBC data source.

ANSI Databases Isolation Level

• Informix ANSI databases support Repeatable Read and Serializable transaction isolation levels. It is recommended to change the driver default isolation level from Repeatable Read to Read Committed to avoid issues with synchronizing data.

ODBC Data Source Setup

IBM Informix ODBC Error Message
Test connection was NOT successful.[Informix][Informix ODBC Driver][Informix]Database locale information mismatch.

Check Use Server Database Locale checkbox in DSN Environment tab.