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.