Informix DBMS Notes CompareData

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
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.

Informix DSN