Was this helpful?
[NO]UNICODE_SUBSTITUTION
When a Unicode value is being coerced into a local character set that has no equivalent character, an error is returned.
If UNICODE_SUBSTITUTION is set for the session, instead of returning the error, unmapped characters are replaced with a designated substitution character. The substitution character is the default subchar value specified in the mapping file. To override this value, provide a character value for the substitution character with this statement.
SET NOUNICODE_SUBSTITUTION in the session reverts to the default behavior.
Last modified date: 08/14/2024