Allowing Unicode Noncharacters

In Adaptive Server version 15.7, the enable permissive unicode configuration parameter, which is a member of enable functionality group, allows you to ignore Unicode noncharacters.

When you enable this feature, Unicode noncharacters are not detected in:

Parameters
- Presented as univarchar and unitext (UTF-16) datatypes
- Presented as varchar and text (UTF-8) datatypes
- As parameters to dynamic SQL statements
- As input to parameterized language statements
- As input to parameterized language statements
String literals when the server’s character set is UTF-8
Escaped string literals (those prefixed with U&), regardless of the server’s character set
Conversion processes between unichar (UTF-16) and varchar (UTF-8) in either direction

In addition, Unicode noncharacters are acceptable in simple expressions such as comparisons, where they sort higher than legal Unicode characters.

In versions of Adaptive Server earlier than 15.7, the unichar, univarchar, unitext, char, varchar, and text datatypes under the utf-8 default character set did not accept Unicode noncharacters (code points permanently reserved for internal use).

See "Setting Configuration Parameters" and "Configuring Client/Server Character Set Conversions" in the System Administration Guide, Volume 1.