EILSEQ_COMPAT_MODE configuration parameter

Use the EILSEQ_COMPAT_MODE configuration parameter to control if HCL OneDB™ 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 = HCL OneDB validates incoming character sequences with the current locale and returns error -202 if any characters are not valid.

1 = HCL OneDB 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.