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.