nls
Enable or disable multibyte character sets.
USYS$Mnemonic_PARAMS = nls : on | off
USYS$Mnemonic_PARAMS = nls : enabled | disabled
Use
Applies to |
Mnemonic |
Connector Syntax |
---|---|---|
MS SQL connector |
MSS |
|
Description
This connector option enables multibyte character sets. See your database documentation for more information.
When the nls
option is on
(or
enabled
), DBMS wildcard literals are not supported. This option has no effect on
Uniface wildcards.
MS SQL
When this option is enabled, fields defined with Char, Varchar, and Text storage formats are mapped to Nchar, Nvarchar, and Ntext respectively. Therefore, the number of bytes assigned to the remapped data type is halved, because a single NLS character requires two bytes, while a non-NLS character requires one byte.