D.16 HS_FDS_REMOTE_DB_CHARSET
HS_FDS_REMOTE_DB_CHARSET
initialization parameter for Oracle Database Gateway for SQL Server.
Property | Description |
---|---|
Default Value |
None |
Range of values |
Not applicable |
Syntax |
|
This parameter is valid only when HS_LANGUAGE
is set to AL32UTF8
and the gateway runs on Windows. As more Oracle databases and non-Oracle databases use Unicode as database character sets, it is preferable to also run the gateway in Unicode character set. To do so, you must set HS_LANGUAGE=AL32UTF8
. However, when the gateway runs on Windows, the Microsoft ODBC Driver Manager interface can exchange data only in the double-byte character set, UCS2. This results in extra ratio expansion of described buffer and column sizes. To compensate, the gateway can re-adjust the column size if HS_FDS_REMOTE_DB_CHARSET
is set to the corresponding non-Oracle database character set. For example, HS_FDS_REMOTE_DB_CHARSET=KO16KSC5601
.
Parent topic: Initialization Parameters