Ignore, Warning, Error

Ignore

Controls what happens if an error is encountered during character conversion, as follows:

When character set conversion is required between the client and the database, this option governs whether to ignore, return a warning, or return an error, when illegal characters are detected, or when character substitution is used.

Single-byte to single-byte converters are not able to report substitutions and illegal characters, and must be set to Ignore.

This option does not control the behavior when lossy conversion takes place on the client. For example, SQL statements from the client must be in, or converted to, the CHAR database character set. Suppose a Unicode client application prepares a SQL statement, and that statement contains characters that cannot be represented in the CHAR database character set. Substitution characters are used instead. However, because the lossy conversion took place on the client, the database server is unaware of the lossy conversion.

• Comparisons between CHAR and NCHAR
• Converting NCHAR to CHAR
• Lossy conversion and substitution characters
• on_charset_conversion_failure connection property