D Globalization Settings

The OracleAS CDC Adapter for SQL Server provides the globalization support for the following languages:

Arabic
English (the default)
French
German
Greek
Hebrew
Italian
Japanese
Korean
Portuguses
Simple Chinese
Spanish
Traditional Chinese
Turkish

This appendix describes how to define the language support.

Defining the Language and Code Page

The language and code page parameters are accessed from the computer where Oracle Studio is installed.

Perform the following steps to define the required language and code page:

From the Start menu, select Programs, Oracle, and then select Studio.
In the Design perspective Configuration view, expand the Machines folder.
Expand the machine for which you want to set the language.
Expand the Bindings folder and right-click the NAV binding.
Select Open.
Expand the Language Settings and do the following:
- From the Language list, select the NLS supported language to use in this binding. Valid values are are listed in the Language Name column of NLS Language Codes table.
- From the Codepage list, select the code page to use with this language. The code pages available are determined by the Language that is selected. If you have additional code pages available, you can manually enter them in this field.
  
  Note: If you change the language, the code page also changes. Ensure that you want to use the selected code page with the language you selected.
  
  If no code page is selected, the default code page for the selected language is used.
- From the NLS string list, select the NLS string for this language and code page. The NLS strings available are determined by the code page that is selected. If you have additional NLS strings available, you can manually enter them in this field.
  
  The code page is used by a field with a data type defined as nlsString. This parameter is used for a field with a code page that is different than the computer's code page. This property includes values for the name of the code page and whether the character set reads from right to left (as in middle-eastern character sets).
  
  For example, the following specifies a Japanese EUC 16-bit code page:
```
<misc nlsString="JA16EUC,false"/>
```
Save the change. New servers are used for the language selected.

The following table lists the code pages:

Table D-1 NLS Language Codes

Language Name	Language Code	Windows Default	ASCII Platforms (Default)	EBCDIC Platforms (Default)	Alternative Code pages(EBCDIC based unless noted otherwise)
English US	ENUS	Windows-1252	ISO-8859-15	IBM1140	IBM285, IBM500, IBM1148, IBM1047,ISO-8859-1 (ASCII based)
English UK	ENUK	Windows-1252	ISO-8859-15	IBM1146	IBM285, IBM037, IBM500, IBM1140, IBM1148, IBM1047,ISO-8859-1 (ASCII based)
French	FRE	Windows-1252	ISO-8859-15	IBM1147	IBM297, IBM037, IBM500, IBM1140, IBM1148, IBM1047,ISO-8859-1 (ASCII based)
Latin International	LAT	Windows-1252	ISO-8859-15	IBM1148	IBM500, IBM037, IBM1140, IBM1047,ISO-8859-1 (ASCII based)
Spanish	SPA	Windows-1252	ISO-8859-15	IBM1145	IBM284, IBM037, IBM500, IBM1140, IBM1148, IBM1047,ISO-8859-1 (ASCII based)
German	GER	Windows-1252	ISO-8859-15	IBM1141	IBM273, IBM037 ,IBM500, IBM1140, IBM1148, IBM1047,ISO-8859-1 (ASCII based)
Portuguese	POR	Windows-1252	ISO-8859-15	IBM1140	IBM037, IBM500, IBM1148, IBM1047,ISO-8859-1 (ASCII based)
Italian	ITL	Windows-1252	ISO-8859-15	IBM1144	IBM280, IBM037, IBM500, IBM1140, IBM1148, IBM1047,ISO-8859-1 (ASCII based)
Greek	GRK	Windows-1253	ISO-8859-7	IBM875	-
Russian^Foot 1	RUS	Windows-1251	ISO-8859-5	IBM1154	IBM1025
Turkish^Foot 2	TUR	Windows-1254	ISO-8859-9	IBM1155	IBM1026
Hebrew	HEB	Windows-1255	ISO-8859-8	IBM424	IBM 862
Arabic	ARA	Windows-1256	ISO-8859-6	IBM420
Japanese	JPN	SJIS	SJIS	IBM939	EUC-JP=EUC, VMS-JP
Chinese - Simplified	SCHI	GBK	GBK	IBM935	-
Chinese - Traditional	TCHI	BIG5	BIG5	IBM937	-
Korean	KOR	MS949	EUC-KR	IBM933	MS949

^Footnote 1 Russian users who use ANSI 1251 Cyrillic as their Windows code page mustedit the RUS.TXT file and compile it to RUS.CP using the NAV_UTIL CODEPAGE.

^Footnote 2To work with solutions in Oracle Studio, when using Turkish, add the -nl en switch to the Target path in the Oracle Studio shortcut properties. For example: "C:\Program Files\Oracle\Studio1\studio.exe -nl en"