Informix - How to Define Database Code Page

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

Informix:

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

Result:

dbs_dbsname	dbs_collate
sales	en_US.819

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

Typical locales:

About SQLines

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

You could leave a comment if you were logged in.