EILSEQ_COMPAT_MODE configuration parameter

Use the EILSEQ_COMPAT_MODE configuration parameter to control if HCL Informix® checks whether character data inserted by a client application contains code point sequences not recognized by the locale of the current database.

onconfig.std value
EILSEQ_COMPAT_MODE 0
values
0 = Informix validates incoming character sequences with the current locale and returns error -202 if any characters are not valid.

1 = Informix does not validate incoming character sequences.

takes effect
After you edit your onconfig file and restart the database server.

Usage

If you set the EILSEQ_COMPAT_MODE configuration parameter to 0, only valid byte sequences can be inserted to the database.

The EILSEQ_COMPAT_MODE configuration parameter prevents a 202 error in these conditions:

  • When data is being retrieved from the database.
  • When an invalid character is at the end of the string and is a partial character.

Copyright© 2018 HCL Technologies Limited