D.33 HS_NLS_LENGTH_SEMANTICS

HS_NLS_LENGTH_SEMANTICS initialization parameter for Oracle Database Gateway for SQL Server.

Property	Description
Default Value	BYTE
Range of Values	BYTE | CHAR
Syntax	HS_NLS_LENGTH_SEMANTICS = { BYTE | CHAR }

This release of gateway has Character Semantics functionality equivalent to the Oracle Database Character Semantics, that is, NLS_LENGTH_SEMANTICS. When HS_NLS_LENGTH_SEMANTICS is set to CHAR, the (VAR)CHAR columns of SQL Server database are to be interpreted as having CHAR semantics. The only situation the gateway does not honor the HS_NLS_LENGTH_SEMANTICS=CHAR setting is when both Oracle database and the gateway are on the same multi-byte character set