Normally, AIS assumes that all string fields are encoded in the system codepages. However, there are cases where some (or even all) the string fields are encoded in a different codepage than the system codepage (e.g., a 7-bit encoding).

To handle such cases, AIS defines a special string type called nls_String. Strings in the database that are defined as nls_Strings are converted automatically to the system codepage when they are read from the database, and are converted back from the system codepage when they are written to the database.

To use this data type, change the tables to use this data type rather than STRING and then tell the product which encoding to use for NLS strings. This involves two steps:

1. Defining the data type of a field as nlsString.
2. Specifying the nlsString parameter of the environment setting.

To define a field's data type as nlsString
Note

A field is defined with a data type of nlsString using Studio, in the Design perspective.

1. In the Configuration view, right-click the data source, and select Edit Metadata.

The Metadata tab opens with the selected data source displayed in the Configuration view.

2. Select the table that contains the field, right-click and choose Edit.

3. In the Columns tab, select the field and specify nlsString as the data type.

To define the nlsString environment properties
Note
: The language and codepage is set using Studio, in the Design perspective.

1. In the Configuration view, click the machine with the binding configuration you want to set.

2. Under the Bindings node, select the relevant binding configuration.

3. Right-click the binding configuration and select Edit Binding.
The environment properties are listed in the Properties tab. The nlsString property is set under the misc group.

4. In the Value field for the nlsString property, specify the name of the codepage and, optionally, a comma and whether the character set reads from right to left (as in Middle Eastern character sets).

The default is false (read from left to right).

Examples

Specifying the following in the Value field defines a Japanese EUC 16 bit code page:

JA16EUC

Specifying the following in the Value field defines an Israeli standard 960 7-bit Latin/Hebrew (ASCII 7-bit), where the character set reads from right to left:

IW7IS960,true