Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 6 Specification of NLS Characteristics – @NLS1 Table : Restrictions on locale.codepage

Restrictions on locale.codepage
The values entered for the locale.codepage for SELF and REMOTE must (when default values are resolved as described) specify a locale part that is consistent with the code page specification.
If the value is not specified as described in Enabling NLS, the login session fails NLS initialization and terminates the session. A database administrator (or other level‑7 user) must modify entries in the @NLS1 table to create or restore a correct and valid state.
Values for SELF
Code page
The code page part for SELF must correctly specify the current code page of the customer TDS character data. If you specify another value (for example, ENGL.IBM‑037), some character data could be corrupted and character strings could be folded incorrectly.
For Open Systems, the only valid code page parts for the SELF occurrence are IBM-037 and IBM-1140. It is the responsibility of the enterprise database administrator to ensure this requirement is met. Failure to do so can result in data corruption or NLS initialization failure.
Locale
The locale part for SELF must be the same value as the locale part for REMOTE.
Values for REMOTE
Code page
The code page part for the REMOTE occurrence of each peer Data Object Broker in an enterprise-wide cluster must (when default values are resolved as described) specify the same value.
The enterprise database administrator must ensure that this requirement is met. Failure to ensure equivalence can result in peer data corruption and/or the inability to interoperate (for example, an access error could occur on peer data requests).
Locale
The locale part for REMOTE on each peer Data Object Broker in an enterprise-wide cluster must (when default values are resolved as described) specify the same value.
The enterprise database administrator must ensure that this requirement is met. Failure to ensure equivalence can result in peer data corruption and/or the inability to interoperate (for example, an access error could occur on peer data requests).
Values for ASCII
Code page
The code page part for the ASCII occurrence describes the ASCII code page to be used to display ASCII data. This code page must be compatible with the TDS code page specified in the SELF occurrence. For a TDS code page of IBM-037, either ISO-8859-1 or WIN-1252 is valid for the ASCII code page. For a TDS code page of IBM-1140, either ISO-8859-15 or WIN-1252 is valid for the ASCII code page.
Valid locale.codepage Specifications
The following table lists valid locale.codepage specifications:
CDNB.IBM‑037 or CDNB.IBM-1140
Canadian Bilingual
DANS.IBM‑037 or DANS.IBM-1140
DANS.IBM‑277 or DANS.IBM-1142
DEUT.IBM‑037 or DEUT.IBM-1140
DEUT.IBM‑273 or DEUT.IBM-1141
ENGB.IBM‑037 or ENGB.IBM-1140
ENGB.IBM‑285 or ENGB.IBM-1146
ENGL.IBM‑037 or ENGL.IBM-1140
ESPA.IBM‑037 or ESPA.IBM-1140
ESPA.IBM‑284 or ESPA.IBM-1145
FRAN.IBM‑037 or FRAN.IBM-1140
FRAN.IBM‑297 or FRAN.IBM-1147
ITAL.IBM‑037 or ITAL.IBM-1140
ITAL.IBM‑280 or ITAL.IBM-1144
NORS.IBM‑037 or NORS.IBM-1140
NORS.IBM‑277 or NORS.IBM-1142
PORT. IBM‑037 or PORT.IBM-1140
PORT. IBM‑282
SCHW.IBM‑037 or SCHW.IBM-1140
SCHW.IBM‑500 or SCHW.IBM-1148
SUOM.IBM‑037 or SUOM.IBM-1140
SUOM.IBM‑278 or SUOM.IBM-1143
SVEN.IBM‑037 or SVEN.IBM-1140
SVEN.IBM‑278 or SVEN.IBM-1143
In addition, the ENGL locale is supported with all the above code pages (for example, ENGL.IBM‑278).

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved