Informix - How to Define Database Code Page

You can use the following query to define the codepage (locale) of a database in Informix:


  -- Define locale of SALES database
  SELECT * FROM sysmaster:sysdbslocale WHERE dbs_dbsname = 'sales'


dbs_dbsname dbs_collate
sales en_US.819

Note that 819 codepage in Informix corresponds to Latin 1 - ISO 8859-1 codepage.

Typical locales:

dbs_collate locale
1 en_US.819 Latin 1, ISO 8859-1
2 en_US.57372 UTF-8

About SQLines

SQLines offers services and tools to help you migrate databases and applications. For more information, please contact us at

You could leave a comment if you were logged in.