The following tables show the languages and code sets supported
by the database servers, and how these values are mapped to territory
code and code page values that are used by the database manager.
You can use any supported code page on any supported platform,
except where the operating system is specified as "host". For example,
you can create a database using code set 1252 on AIX®, even though the operating system itself
does not support the 1252 code page.
When creating a database,
specify the two- or three-letter territory identifier (found in the
title of each table) as the
TERRITORY parameter.
For example, use the following syntax to create a database using the
Arabic territory identifier on the AIX operating
system.
CREATE DATABASE TESTDB1 USING CODESET ISO8859-6 TERRITORY AA
Note: The CREATE
DATABASE command accepts a valid territory identifier or
a valid locale as the TERRITORY parameter.
The
following is an explanation of the columns in the tables:
- Code page shows the IBM-defined code page as mapped from the operating
system code set.
- Group shows whether a code
page is single byte ("S"), double-byte ("D"), or neutral ("N"). The "-n" is a number used to create
a letter-number combination. Matching combinations show where connection and conversion is allowed
by Db2® database
systems. For example, all "S-1" groups can work together. However, if the group is neutral, then
connection and conversion with any other code page listed is allowed. Graphic strings are not
supported where the group indicates that the code page is single byte.
- Code set shows the code set associated with the supported language. The code set is
mapped to the Db2 code page.
- Territory code shows the code that is used by the database
manager internally to provide region-specific support.
- Collation shows the default collation for non-Unicode databases.
- Locale shows the locale values supported by the database
manager.
- Operating system shows the operating system that supports the languages and code sets.
When used in this column, the word
host
refers to an operating system such as z/OS® that supports the EBCDIC code pages natively. Note that Linux® on z/OS is not a
host platform. You cannot use Db2 database manager to
create a database in a host code page, but you can use Db2 database manager to
connect to a host database in a supported host code page.
Table 1. Unicode
Code page |
Group |
Code set |
Territory code |
Locale |
Operating system |
1200 |
N-1 |
16-bit Unicode |
Any |
Any |
Any |
1208 |
N-1 |
UTF-8 encoding of Unicode |
Any |
Any |
Any |
Table 2. Albania, territory
identifier: AL
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
819 |
S-1 |
ISO8859-1 |
355 |
Code page 819, Generic (SYSTEM_819) |
sq_AL |
AIX |
850 |
S-1 |
IBM-850 |
355 |
Code page 850, Generic (SYSTEM_850) |
- |
AIX |
923 |
S-1 |
ISO8859-15 |
355 |
Code page 923, Generic (SYSTEM_923) |
sq_AL.8859-15 |
AIX |
1208 |
N-1 |
UTF-8 |
355 |
|
SQ_AL |
AIX |
37 |
S-1 |
IBM-37 |
355 |
|
- |
Host |
1140 |
S-1 |
IBM-1140 |
355 |
|
- |
Host |
819 |
S-1 |
iso88591 |
355 |
Code page 819, Generic (SYSTEM_819) |
- |
- |
923 |
S-1 |
iso885915 |
355 |
Code page 923, Generic (SYSTEM_923) |
- |
- |
1051 |
S-1 |
roman8 |
355 |
Code page 1051, Generic (SYSTEM_1051) |
- |
- |
437 |
S-1 |
IBM-437 |
355 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
850 |
S-1 |
IBM-850 |
355 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
1252 |
S-1 |
1252 |
355 |
Code page 1252, Generic (SYSTEM_1252) |
- |
Windows |
The following map to Arabic Countries/Regions (AA):
- Arabic (Saudi Arabia)
- Arabic (Iraq)
- Arabic (Egypt)
- Arabic (Libya)
- Arabic (Algeria)
- Arabic (Morocco)
- Arabic (Tunisia)
- Arabic (Oman)
- Arabic (Yemen)
- Arabic (Syria)
- Arabic (Jordan)
- Arabic (Lebanon)
- Arabic (Kuwait)
- Arabic (United Arab Emirates)
- Arabic (Bahrain)
- Arabic (Qatar)
Table 4. Armenia, territory identifier: AM
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
1208 |
N-1 |
UTF-8 |
374 |
|
- |
- |
Table 5. Australia, territory
identifier: AU
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
819 |
S-1 |
ISO8859-1 |
61 |
Code page 819, Generic (SYSTEM_819) |
en_AU |
AIX |
850 |
S-1 |
IBM-850 |
61 |
Code page 850, Generic (SYSTEM_850) |
- |
AIX |
923 |
S-1 |
ISO8859-15 |
61 |
Code page 923, Generic (SYSTEM_923) |
en_AU.8859-15 |
AIX |
1208 |
N-1 |
UTF-8 |
61 |
|
EN_AU |
AIX |
37 |
S-1 |
IBM-37 |
61 |
|
- |
Host |
1140 |
S-1 |
IBM-1140 |
61 |
|
- |
Host |
819 |
S-1 |
iso88591 |
61 |
Code page 819, Generic (SYSTEM_819) |
- |
- |
923 |
S-1 |
iso885915 |
61 |
Code page 923, Generic (SYSTEM_923) |
- |
- |
1051 |
S-1 |
roman8 |
61 |
Code page 1051, Generic (SYSTEM_1051) |
- |
- |
437 |
S-1 |
IBM-437 |
61 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
850 |
S-1 |
IBM-850 |
61 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
819 |
S-1 |
ISO8859-1 |
61 |
Code page 819, Generic (SYSTEM_819) |
en_AU |
- |
1252 |
S-1 |
1252 |
61 |
Code page 1252, Generic (SYSTEM_1252) |
- |
Windows |
Table 6. Austria, territory
identifier: AT
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
819 |
S-1 |
ISO8859-1 |
43 |
Code page 819, Generic (SYSTEM_819) |
- |
AIX |
850 |
S-1 |
IBM-850 |
43 |
Code page 850, Generic (SYSTEM_850) |
- |
AIX |
923 |
S-1 |
ISO8859-15 |
43 |
Code page 923, Generic (SYSTEM_923) |
- |
AIX |
1208 |
N-1 |
UTF-8 |
43 |
|
- |
AIX |
37 |
S-1 |
IBM-37 |
43 |
|
- |
Host |
1140 |
S-1 |
IBM-1140 |
43 |
|
- |
Host |
819 |
S-1 |
iso88591 |
43 |
Code page 819, Generic (SYSTEM_819) |
- |
- |
923 |
S-1 |
iso885915 |
43 |
Code page 923, Generic (SYSTEM_923) |
- |
- |
1051 |
S-1 |
roman8 |
43 |
Code page 1051, Generic (SYSTEM_1051) |
- |
- |
819 |
S-1 |
ISO-8859-1 |
43 |
Code page 819, Generic (SYSTEM_819) |
de_AT |
Linux |
923 |
S-1 |
ISO-8859-15 |
43 |
Code page 923, Generic (SYSTEM_923) |
de_AT@euro |
Linux |
437 |
S-1 |
IBM-437 |
43 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
850 |
S-1 |
IBM-850 |
43 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
819 |
S-1 |
ISO8859-1 |
43 |
Code page 819, Generic (SYSTEM_819) |
de_AT |
- |
1252 |
S-1 |
1252 |
43 |
Code page 1252, Generic (SYSTEM_1252) |
- |
Windows |
Table 7. Azerbaijan, territory
identifier: AZ
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
1208 |
N-1 |
UTF-8 |
994 |
|
- |
- |
Table 8. Bangladesh, territory identifier: BD
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
1208 |
N-1 |
UTF-8 |
880 |
|
- |
- |
Table 10. Belgium, territory
identifier: BE
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
1051 |
S-1 |
roman8 |
32 |
Code page 1051, Generic (SYSTEM_1051) |
- |
- |
819 |
S-1 |
ISO8859-1 |
32 |
Code page 819, Generic (SYSTEM_819) |
fr_BE |
AIX |
819 |
S-1 |
ISO8859-1 |
32 |
Code page 819, Generic (SYSTEM_819) |
nl_BE |
AIX |
850 |
S-1 |
IBM-850 |
32 |
Code page 850, Generic (SYSTEM_850) |
Fr_BE |
AIX |
850 |
S-1 |
IBM-850 |
32 |
Code page 850, Generic (SYSTEM_850) |
Nl_BE |
AIX |
923 |
S-1 |
ISO8859-15 |
32 |
Code page 923, Generic (SYSTEM_923) |
fr_BE.8859-15 |
AIX |
923 |
S-1 |
ISO8859-15 |
32 |
Code page 923, Generic (SYSTEM_923) |
nl_BE.8859-15 |
AIX |
1208 |
N-1 |
UTF-8 |
32 |
|
FR_BE |
AIX |
1208 |
N-1 |
UTF-8 |
32 |
|
NL_BE |
AIX |
274 |
S-1 |
IBM-274 |
32 |
|
- |
Host |
500 |
S-1 |
IBM-500 |
32 |
|
- |
Host |
1148 |
S-1 |
IBM-1148 |
32 |
|
- |
Host |
819 |
S-1 |
iso88591 |
32 |
Code page 819, Generic (SYSTEM_819) |
- |
- |
923 |
S-1 |
iso885915 |
32 |
Code page 923, Generic (SYSTEM_923) |
- |
- |
819 |
S-1 |
ISO-8859-1 |
32 |
Code page 819, Generic (SYSTEM_819) |
fr_BE |
Linux |
819 |
S-1 |
ISO-8859-1 |
32 |
Code page 819, Generic (SYSTEM_819) |
nl_BE |
Linux |
923 |
S-1 |
ISO-8859-15 |
32 |
Code page 923, Generic (SYSTEM_923) |
fr_BE@euro |
Linux |
923 |
S-1 |
ISO-8859-15 |
32 |
Code page 923, Generic (SYSTEM_923) |
nl_BE@euro |
Linux |
437 |
S-1 |
IBM-437 |
32 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
850 |
S-1 |
IBM-850 |
32 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
819 |
S-1 |
ISO8859-1 |
32 |
Code page 819, Generic (SYSTEM_819) |
fr_BE |
- |
819 |
S-1 |
ISO8859-1 |
32 |
Code page 819, Generic (SYSTEM_819) |
nl_BE |
- |
1252 |
S-1 |
1252 |
32 |
Code page 1252, Generic (SYSTEM_1252) |
- |
Windows |
Table 12. Brazil, territory
identifier: BR
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
437 |
S-1 |
IBM-437 |
55 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
1051 |
S-1 |
roman8 |
55 |
Code page 1051, Generic (SYSTEM_1051) |
- |
- |
819 |
S-1 |
ISO8859-1 |
55 |
Code page 819, Generic (SYSTEM_819) |
pt_BR |
AIX |
850 |
S-1 |
IBM-850 |
55 |
Code page 850, Generic (SYSTEM_850) |
- |
AIX |
923 |
S-1 |
ISO8859-15 |
55 |
Code page 923, Generic (SYSTEM_923) |
pt_BR.8859-15 |
AIX |
1208 |
N-1 |
UTF-8 |
55 |
|
PT_BR |
AIX |
37 |
S-1 |
IBM-37 |
55 |
|
- |
Host |
1140 |
S-1 |
IBM-1140 |
55 |
|
- |
Host |
819 |
S-1 |
ISO8859-1 |
55 |
Code page 819, Generic (SYSTEM_819) |
- |
- |
923 |
S-1 |
ISO8859-15 |
55 |
Code page 923, Generic (SYSTEM_923) |
- |
- |
819 |
S-1 |
ISO-8859-1 |
55 |
Code page 819, Generic (SYSTEM_819) |
pt_BR |
Linux |
923 |
S-1 |
ISO-8859-15 |
55 |
Code page 923, Generic (SYSTEM_923) |
- |
Linux |
850 |
S-1 |
IBM-850 |
55 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
819 |
S-1 |
ISO8859-1 |
55 |
Code page 819, Generic (SYSTEM_819) |
pt_BR |
- |
1252 |
S-1 |
1252 |
55 |
Code page 1252, Generic (SYSTEM_1252) |
- |
Windows |
Table 13. Cambodia, territory identifier: KH
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
1208 |
N-1 |
UTF-8 |
855 |
|
- |
- |
Table 14. Canada, territory
identifier: CA
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
437 |
S-1 |
IBM-437 |
2 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
819 |
S-1 |
ISO8859-1 |
2 |
Code page 819, Generic (SYSTEM_819) |
fr_CA |
AIX |
850 |
S-1 |
IBM-850 |
2 |
Code page 850, Generic (SYSTEM_850) |
Fr_CA |
AIX |
923 |
S-1 |
ISO8859-15 |
2 |
Code page 923, Generic (SYSTEM_923) |
fr_CA.8859-15 |
AIX |
1208 |
N-1 |
UTF-8 |
2 |
|
FR_CA |
AIX |
37 |
S-1 |
IBM-37 |
2 |
|
- |
Host |
1140 |
S-1 |
IBM-1140 |
2 |
|
- |
Host |
819 |
S-1 |
iso88591 |
2 |
Code page 819, Generic (SYSTEM_819) |
fr_CA.iso88591 |
- |
923 |
S-1 |
iso885915 |
2 |
Code page 923, Generic (SYSTEM_923) |
- |
- |
1051 |
S-1 |
roman8 |
2 |
Code page 1051, Generic (SYSTEM_1051) |
fr_CA.roman8 |
- |
819 |
S-1 |
ISO-8859-1 |
2 |
Code page 819, Generic (SYSTEM_819) |
en_CA |
Linux |
923 |
S-1 |
ISO-8859-15 |
2 |
Code page 923, Generic (SYSTEM_923) |
- |
Linux |
850 |
S-1 |
IBM-850 |
2 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
819 |
S-1 |
ISO8859-1 |
2 |
Code page 819, Generic (SYSTEM_819) |
en_CA |
- |
819 |
S-1 |
ISO8859-1 |
2 |
Code page 819, Generic (SYSTEM_819) |
fr_CA |
- |
1252 |
S-1 |
1252 |
2 |
Code page 1252, Generic (SYSTEM_1252) |
- |
Windows |
863 |
S-1 |
IBM-863 |
2 |
Code page 863, Generic (SYSTEM_863) |
- |
- |
Table 15. China
(PRC), territory identifier: CN
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
437 |
S-1 |
IBM-437 |
86 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
819 |
S-1 |
ISO8859-1 |
86 |
Code page 819, Generic (SYSTEM_819) |
- |
- |
850 |
S-1 |
IBM-850 |
86 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
923 |
S-1 |
ISO8859-15 |
86 |
Code page 923, Generic (SYSTEM_923) |
- |
- |
1051 |
S-1 |
roman8 |
86 |
Code page 1051, Generic (SYSTEM_1051) |
- |
- |
1383 |
D-4 |
IBM-eucCN |
86 |
Code page 1383, Generic (SYSTEM_1383) |
zh_CN |
AIX |
1386 |
D-4 |
GBK |
86 |
Code page 1386, Generic (SYSTEM_1386) |
Zh_CN.GBK |
AIX |
1208 |
N-1 |
UTF-8 |
86 |
|
ZH_CN |
AIX |
935 |
D-4 |
IBM-935 |
86 |
|
- |
Host |
1388 |
D-4 |
IBM-1388 |
86 |
|
- |
Host |
1383 |
D-4 |
hp15CN |
86 |
Code page 1383, Generic (SYSTEM_1383) |
zh_CN.hp15CN |
- |
1386 |
D-4 |
GBK |
86 |
Code page 1386, Generic (SYSTEM_1386) |
zh_CN.GBK |
Linux |
1381 |
D-4 |
IBM-1381 |
86 |
Code page 1381, Generic (SYSTEM_1381) |
- |
- |
1386 |
D-4 |
GBK |
86 |
Code page 1386, Generic (SYSTEM_1386) |
- |
- |
1383 |
D-4 |
eucCN |
86 |
Code page 1383, Generic (SYSTEM_1383) |
zh_CN |
- |
1383 |
D-4 |
eucCN |
86 |
Code page 1383, Generic (SYSTEM_1383) |
zh_CN.eucCN |
- |
1381 |
D-4 |
IBM-1381 |
86 |
Code page 1381, Generic (SYSTEM_1381) |
- |
Windows |
1386 |
D-4 |
GBK |
86 |
Code page 1386, Generic (SYSTEM_1386) |
- |
Windows |
1392 |
D-6 |
GB18030 |
86 |
|
Zh_CN.GB18030 |
AIX |
1392 |
D-6 |
GB18030 |
86 |
|
zh_CN.gb18030 |
Linux |
See notes 4 and 7. |
The following map to Chinese-simplified (China):
- Chinese-simplified (Singapore)
Table 18. Denmark, territory
identifier: DK
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
437 |
S-1 |
IBM-437 |
45 |
Code page 437, Denmark (SYSTEM_437_DK) |
- |
- |
819 |
S-1 |
ISO8859-1 |
45 |
Code page 819, Denmark (SYSTEM_819_DK) |
da_DK |
AIX |
850 |
S-1 |
IBM-850 |
45 |
Code page 850, Denmark (SYSTEM_850_DK) |
Da_DK |
AIX |
923 |
S-1 |
ISO8859-15 |
45 |
Code page 923, Denmark (SYSTEM_923_DK) |
da_DK.8859-15 |
AIX |
1208 |
N-1 |
UTF-8 |
45 |
|
DA_DK |
AIX |
277 |
S-1 |
IBM-277 |
45 |
|
- |
Host |
1142 |
S-1 |
IBM-1142 |
45 |
|
- |
Host |
819 |
S-1 |
iso88591 |
45 |
Code page 819, Denmark (SYSTEM_819_DK) |
da_DK.iso88591 |
- |
923 |
S-1 |
iso885915 |
45 |
Code page 923, Denmark (SYSTEM_923_DK) |
_ |
- |
1051 |
S-1 |
roman8 |
45 |
Code page 1051, Denmark (SYSTEM_1051_DK) |
da_DK.roman8 |
- |
819 |
S-1 |
ISO-8859-1 |
45 |
Code page 819, Denmark (SYSTEM_819_DK) |
da_DK |
Linux |
923 |
S-1 |
ISO-8859-15 |
45 |
Code page 923, Denmark (SYSTEM_923_DK) |
- |
Linux |
850 |
S-1 |
IBM-850 |
45 |
Code page 850, Denmark (SYSTEM_850_DK) |
- |
- |
819 |
S-1 |
ISO8859-1 |
45 |
Code page 819, Denmark (SYSTEM_819_DK) |
da |
- |
819 |
S-1 |
ISO8859-1 |
45 |
Code page 819, Denmark (SYSTEM_819_DK) |
da_DA |
- |
819 |
S-1 |
ISO8859-1 |
45 |
Code page 819, Denmark (SYSTEM_819_DK) |
da_DK |
- |
1252 |
S-1 |
1252 |
45 |
Code page 1252, Denmark (SYSTEM_1252_DK) |
- |
Windows |
Table 21. Finland, territory
identifier: FI
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
819 |
S-1 |
ISO8859-1 |
358 |
Code page 819, Finland and Sweden (SYSTEM_819_FI and SYSTEM_819_SE) |
fi_FI |
AIX |
850 |
S-1 |
IBM-850 |
358 |
Code page 850, Finland and Sweden (SYSTEM_850_FI and SYSTEM_850_SE) |
Fi_FI |
AIX |
923 |
S-1 |
ISO8859-15 |
358 |
Code page 923, Finland and Sweden (SYSTEM_923_FI and SYSTEM_923_SE) |
fi_FI.8859-15 |
AIX |
1208 |
N-1 |
UTF-8 |
358 |
|
FI_FI |
AIX |
278 |
S-1 |
IBM-278 |
358 |
|
- |
Host |
1143 |
S-1 |
IBM-1143 |
358 |
|
- |
Host |
819 |
S-1 |
iso88591 |
358 |
Code page 819, Finland and Sweden (SYSTEM_819_FI and SYSTEM_819_SE) |
fi_FI.iso88591 |
- |
923 |
S-1 |
iso885915 |
358 |
Code page 923, Finland and Sweden (SYSTEM_923_FI and SYSTEM_923_SE) |
- |
- |
1051 |
S-1 |
roman8 |
358 |
Code page 1051, Finland and Sweden (SYSTEM_1051_FI and SYSTEM_1051_SE) |
fi-FI.roman8 |
- |
819 |
S-1 |
ISO-8859-1 |
358 |
Code page 819, Finland and Sweden (SYSTEM_819_FI and SYSTEM_819_SE) |
fi_FI |
Linux |
923 |
S-1 |
ISO-8859-15 |
358 |
Code page 923, Finland and Sweden (SYSTEM_923_FI and SYSTEM_923_SE) |
fi_FI@euro |
Linux |
437 |
S-1 |
IBM-437 |
358 |
Code page 437, Finland and Sweden (SYSTEM_437_FI and SYSTEM_437_SE) |
- |
- |
850 |
S-1 |
IBM-850 |
358 |
Code page 850, Finland and Sweden (SYSTEM_850_FI and SYSTEM_850_SE) |
- |
- |
819 |
S-1 |
ISO8859-1 |
358 |
Code page 819, Finland and Sweden (SYSTEM_819_FI and SYSTEM_819_SE) |
|
- |
819 |
S-1 |
ISO8859-1 |
358 |
Code page 819, Finland and Sweden (SYSTEM_819_FI and SYSTEM_819_SE) |
fi_FI |
- |
819 |
S-1 |
ISO8859-1 |
358 |
Code page 819, Finland and Sweden (SYSTEM_819_FI and SYSTEM_819_SE) |
sv_FI |
- |
1252 |
S-1 |
1252 |
358 |
Code page 1252, Finland and Sweden (SYSTEM_1252_FI and SYSTEM_1252_SE) |
- |
Windows |
Table 23. France, territory
identifier: FR
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
819 |
S-1 |
ISO8859-1 |
33 |
Code page 819, Generic (SYSTEM_819) |
fr_FR |
AIX |
850 |
S-1 |
IBM-850 |
33 |
Code page 850, Generic (SYSTEM_850) |
Fr_FR |
AIX |
923 |
S-1 |
ISO8859-15 |
33 |
Code page 923, Generic (SYSTEM_923) |
fr_FR.8859-15 |
AIX |
1208 |
N-1 |
UTF-8 |
33 |
|
FR_FR |
AIX |
297 |
S-1 |
IBM-297 |
33 |
|
- |
Host |
1147 |
S-1 |
IBM-1147 |
33 |
|
- |
Host |
819 |
S-1 |
iso88591 |
33 |
Code page 819, Generic (SYSTEM_819) |
fr_FR.iso88591 |
- |
923 |
S-1 |
iso885915 |
33 |
Code page 923, Generic (SYSTEM_923) |
- |
- |
1051 |
S-1 |
roman8 |
33 |
Code page 1051, Generic (SYSTEM_1051) |
fr_FR.roman8 |
- |
819 |
S-1 |
ISO-8859-1 |
33 |
Code page 819, Generic (SYSTEM_819) |
fr_FR |
Linux |
923 |
S-1 |
ISO-8859-15 |
33 |
Code page 923, Generic (SYSTEM_923) |
fr_FR@euro |
Linux |
437 |
S-1 |
IBM-437 |
33 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
850 |
S-1 |
IBM-850 |
33 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
819 |
S-1 |
ISO8859-1 |
33 |
Code page 819, Generic (SYSTEM_819) |
|
- |
819 |
S-1 |
ISO8859-1 |
33 |
Code page 819, Generic (SYSTEM_819) |
fr_FR |
- |
1252 |
S-1 |
1252 |
33 |
Code page 1252, Generic (SYSTEM_1252) |
- |
Windows |
The following map to French (France):
Table 24. Georgia, territory identifier: GE
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
1208 |
N-1 |
UTF-8 |
995 |
|
- |
- |
Table 25. Germany, territory
identifier: DE
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
819 |
S-1 |
ISO8859-1 |
49 |
Code page 819, Generic (SYSTEM_819) |
de_DE |
AIX |
850 |
S-1 |
IBM-850 |
49 |
Code page 850, Generic (SYSTEM_850) |
De_DE |
AIX |
923 |
S-1 |
ISO8859-15 |
49 |
Code page 923, Generic (SYSTEM_923) |
de_DE.8859-15 |
AIX |
1208 |
N-1 |
UTF-8 |
49 |
|
DE_DE |
AIX |
273 |
S-1 |
IBM-273 |
49 |
|
- |
Host |
1141 |
S-1 |
IBM-1141 |
49 |
|
- |
Host |
819 |
S-1 |
iso88591 |
49 |
Code page 819, Generic (SYSTEM_819) |
de_DE.iso88591 |
- |
923 |
S-1 |
iso885915 |
49 |
Code page 923, Generic (SYSTEM_923) |
_ |
- |
1051 |
S-1 |
roman8 |
49 |
Code page 1051, Generic (SYSTEM_1051) |
de_DE.roman8 |
- |
819 |
S-1 |
ISO-8859-1 |
49 |
Code page 819, Generic (SYSTEM_819) |
de_DE |
Linux |
923 |
S-1 |
ISO-8859-15 |
49 |
Code page 923, Generic (SYSTEM_923) |
de_DE@euro |
Linux |
437 |
S-1 |
IBM-437 |
49 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
850 |
S-1 |
IBM-850 |
49 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
819 |
S-1 |
ISO8859-1 |
49 |
Code page 819, Generic (SYSTEM_819) |
|
- |
819 |
S-1 |
ISO8859-1 |
49 |
Code page 819, Generic (SYSTEM_819) |
de_DE |
- |
1252 |
S-1 |
1252 |
49 |
Code page 1252, Generic (SYSTEM_1252) |
- |
Windows |
The following map to German (Germany):
Table 27. Hong Kong S.A.R.
of China, territory identifier: HK
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
1208 |
N-1 |
UTF-8 |
852 |
|
ZH_HK |
AIX |
1208 |
N-1 |
UTF-8 |
852 |
|
zh_HK.utf8 |
- |
1375 |
D-5 |
Big5-HKSCS |
852 |
|
zh_HK.hkbig5 |
- |
1208 |
N-1 |
UTF-8 |
852 |
|
zh_HK.utf8 |
Linux |
1375 |
D-5 |
Big5-HKSCS |
852 |
|
zh_HK |
Linux |
1208 |
N-1 |
UTF-8 |
852 |
|
- |
Windows |
1375 |
D-5 |
Big5-HKSCS |
852 |
|
- |
Windows |
See note 6.
Table 29. Iceland, territory
identifier: IS
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
437 |
S-1 |
IBM-437 |
354 |
Code page 437, Iceland (SYSTEM_437_IS) |
- |
- |
819 |
S-1 |
ISO8859-1 |
354 |
Code page 819 and 923, Iceland (SYSTEM_819_IS and SYSTEM_923_IS) |
is_IS |
AIX |
850 |
S-1 |
IBM-850 |
354 |
Code page 850, Iceland (SYSTEM_850_IS) |
Is_IS |
AIX |
923 |
S-1 |
ISO8859-15 |
354 |
Code page 819 and 923, Iceland (SYSTEM_819_IS and SYSTEM_923_IS) |
is_IS.8859-15 |
AIX |
1208 |
N-1 |
UTF-8 |
354 |
|
IS_IS |
AIX |
871 |
S-1 |
IBM-871 |
354 |
|
- |
Host |
1149 |
S-1 |
IBM-1149 |
354 |
|
- |
Host |
819 |
S-1 |
iso88591 |
354 |
Code page 819 and 923, Iceland (SYSTEM_819_IS and SYSTEM_923_IS) |
is_IS.iso88591 |
- |
923 |
S-1 |
iso885915 |
354 |
Code page 819 and 923, Iceland (SYSTEM_819_IS and SYSTEM_923_IS) |
- |
- |
1051 |
S-1 |
roman8 |
354 |
Code page 1051, Iceland (SYSTEM_1051_IS) |
is_IS.roman8 |
- |
819 |
S-1 |
ISO-8859-1 |
354 |
Code page 819 and 923, Iceland (SYSTEM_819_IS and SYSTEM_923_IS) |
is_IS |
Linux |
923 |
S-1 |
ISO-8859-15 |
354 |
Code page 819 and 923, Iceland (SYSTEM_819_IS and SYSTEM_923_IS) |
- |
Linux |
850 |
S-1 |
IBM-850 |
354 |
Code page 850, Iceland (SYSTEM_850_IS) |
- |
- |
819 |
S-1 |
ISO8859-1 |
354 |
Code page 819 and 923, Iceland (SYSTEM_819_IS and SYSTEM_923_IS) |
|
- |
819 |
S-1 |
ISO8859-1 |
354 |
Code page 819 and 923, Iceland (SYSTEM_819_IS and SYSTEM_923_IS) |
is_IS |
- |
1252 |
S-1 |
1252 |
354 |
Code page 1252, Iceland (SYSTEM_1252_IS) |
- |
Windows |
The following Indic scripts are supported through Unicode:
Hindi, Gujarati, Kannada, Konkani, Marathi, Punjabi, Sanskrit, Tamil
and Telugu.
Table 32. Ireland, territory
identifier: IE
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
819 |
S-1 |
ISO8859-1 |
353 |
Code page 819, Generic (SYSTEM_819) |
- |
AIX |
850 |
S-1 |
IBM-850 |
353 |
Code page 850, Generic (SYSTEM_850) |
- |
AIX |
923 |
S-1 |
ISO8859-15 |
353 |
Code page 923, Generic (SYSTEM_923) |
- |
AIX |
1208 |
N-1 |
UTF-8 |
353 |
|
- |
AIX |
285 |
S-1 |
IBM-285 |
353 |
|
- |
Host |
1146 |
S-1 |
IBM-1146 |
353 |
|
- |
Host |
819 |
S-1 |
iso88591 |
353 |
Code page 819, Generic (SYSTEM_819) |
- |
- |
923 |
S-1 |
iso885915 |
353 |
Code page 923, Generic (SYSTEM_923) |
- |
- |
1051 |
S-1 |
roman8 |
353 |
Code page 1051, Generic (SYSTEM_1051) |
- |
- |
819 |
S-1 |
ISO-8859-1 |
353 |
Code page 819, Generic (SYSTEM_819) |
en_IE |
Linux |
923 |
S-1 |
ISO-8859-15 |
353 |
Code page 923, Generic (SYSTEM_923) |
en_IE@euro |
Linux |
437 |
S-1 |
IBM-437 |
353 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
850 |
S-1 |
IBM-850 |
353 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
819 |
S-1 |
ISO8859-1 |
353 |
Code page 819, Generic (SYSTEM_819) |
en_IE.ISO8859-1 |
- |
1252 |
S-1 |
1252 |
353 |
Code page 1252, Generic (SYSTEM_1252) |
- |
Windows |
Table 34. Italy, territory
identifier: IT
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
819 |
S-1 |
ISO8859-1 |
39 |
Code page 819, Generic (SYSTEM_819) |
it_IT |
AIX |
850 |
S-1 |
IBM-850 |
39 |
Code page 850, Generic (SYSTEM_850) |
It_IT |
AIX |
923 |
S-1 |
ISO8859-15 |
39 |
Code page 923, Generic (SYSTEM_923) |
it_IT.8859-15 |
AIX |
1208 |
N-1 |
UTF-8 |
39 |
|
It_IT |
AIX |
280 |
S-1 |
IBM-280 |
39 |
|
- |
Host |
1144 |
S-1 |
IBM-1144 |
39 |
|
- |
Host |
819 |
S-1 |
iso88591 |
39 |
Code page 819, Generic (SYSTEM_819) |
it_IT.iso88591 |
- |
923 |
S-1 |
iso885915 |
39 |
Code page 923, Generic (SYSTEM_923) |
_ |
- |
1051 |
S-1 |
roman8 |
39 |
Code page 1051, Generic (SYSTEM_1051) |
it_IT.roman8 |
- |
819 |
S-1 |
ISO-8859-1 |
39 |
Code page 819, Generic (SYSTEM_819) |
it_IT |
Linux |
923 |
S-1 |
ISO-8859-15 |
39 |
Code page 923, Generic (SYSTEM_923) |
it_IT@euro |
Linux |
437 |
S-1 |
IBM-437 |
39 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
850 |
S-1 |
IBM-850 |
39 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
819 |
S-1 |
ISO8859-1 |
39 |
Code page 819, Generic (SYSTEM_819) |
|
- |
819 |
S-1 |
ISO8859-1 |
39 |
Code page 819, Generic (SYSTEM_819) |
it_IT |
- |
1252 |
S-1 |
1252 |
39 |
Code page 1252, Generic (SYSTEM_1252) |
- |
Windows |
Table 35. Japan, territory
identifier: JP
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
437 |
S-1 |
IBM-437 |
81 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
819 |
S-1 |
ISO8859-1 |
81 |
Code page 819, Generic (SYSTEM_819) |
- |
- |
850 |
S-1 |
IBM-850 |
81 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
923 |
S-1 |
ISO8859-15 |
81 |
Code page 923, Generic (SYSTEM_923) |
- |
- |
1051 |
S-1 |
roman8 |
81 |
Code page 1051, Generic (SYSTEM_1051) |
- |
- |
932 |
D-1 |
IBM-932 |
81 |
Code page 932 and 943, Generic (SYSTEM_932 and SYSTEM_943) |
Ja_JP |
AIX |
943 |
D-1 |
IBM-943 |
81 |
Code page 932 and 943, Generic (SYSTEM_932 and SYSTEM_943) |
Ja_JP |
AIX |
See note 1. |
954 |
D-1 |
IBM-eucJP |
81 |
Code page 954, Generic (SYSTEM_954) |
ja_JP |
AIX |
1208 |
N-1 |
UTF-8 |
81 |
|
JA_JP |
AIX |
930 |
D-1 |
IBM-930 |
81 |
|
- |
Host |
939 |
D-1 |
IBM-939 |
81 |
|
- |
Host |
5026 |
D-1 |
IBM-5026 |
81 |
|
- |
Host |
5035 |
D-1 |
IBM-5035 |
81 |
|
- |
Host |
1390 |
D-1 |
|
81 |
|
- |
Host |
1399 |
D-1 |
|
81 |
|
- |
Host |
954 |
D-1 |
eucJP |
81 |
Code page 954, Generic (SYSTEM_954) |
ja_JP.eucJP |
- |
5039 |
D-1 |
SJIS |
81 |
Code page 942 and 5039, Generic (SYSTEM_942 and SYSTEM_5039) |
ja_JP.SJIS |
- |
954 |
D-1 |
EUC-JP |
81 |
Code page 954, Generic (SYSTEM_954) |
ja_JP |
Linux |
932 |
D-1 |
IBM-932 |
81 |
Code page 932 and 943, Generic (SYSTEM_932 and SYSTEM_943) |
- |
- |
942 |
D-1 |
IBM-942 |
81 |
Code page 942 and 5039, Generic (SYSTEM_942 and SYSTEM_5039) |
- |
- |
943 |
D-1 |
IBM-943 |
81 |
Code page 932 and 943, Generic (SYSTEM_932 and SYSTEM_943) |
- |
- |
954 |
D-1 |
eucJP |
81 |
Code page 954, Generic (SYSTEM_954) |
ja |
- |
954 |
D-1 |
eucJP |
81 |
Code page 954, Generic (SYSTEM_954) |
ja_JP |
- |
954 |
D-1 |
eucJP |
81 |
Code page 954, Generic (SYSTEM_954) |
ja_JP.EUC |
- |
954 |
D-1 |
eucJP |
81 |
Code page 954, Generic (SYSTEM_954) |
ja_JP.eucJP |
- |
943 |
D-1 |
IBM-943 |
81 |
Code page 932 and 943, Generic (SYSTEM_932 and SYSTEM_943) |
- |
Windows |
1394 |
D-1 |
|
81 |
|
- |
- |
See note 2. |
Table 38. Korea, South, territory
identifier: KR
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
437 |
S-1 |
IBM-437 |
82 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
819 |
S-1 |
ISO8859-1 |
82 |
Code page 819, Generic (SYSTEM_819) |
- |
- |
850 |
S-1 |
IBM-850 |
82 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
923 |
S-1 |
ISO8859-15 |
82 |
Code page 923, Generic (SYSTEM_923) |
- |
- |
1051 |
S-1 |
roman8 |
82 |
Code page 1051, Generic (SYSTEM_1051) |
- |
- |
970 |
D-3 |
IBM-eucKR |
82 |
Code page 970, Generic (SYSTEM_970) |
ko_KR |
AIX |
1208 |
N-1 |
UTF-8 |
82 |
|
KO_KR |
AIX |
933 |
D-3 |
IBM-933 |
82 |
|
- |
Host |
1364 |
D-3 |
IBM-1364 |
82 |
|
- |
Host |
970 |
D-3 |
eucKR |
82 |
Code page 970, Generic (SYSTEM_970) |
ko_KR.eucKR |
- |
970 |
D-3 |
EUC-KR |
82 |
Code page 970, Generic (SYSTEM_970) |
ko_KR |
Linux |
949 |
D-3 |
IBM-949 |
82 |
Code page 949, Generic (SYSTEM_949) |
- |
- |
1363 |
D-3 |
1363 |
82 |
Code page 1363, Generic (SYSTEM_1363) |
- |
Windows |
Table 39. Latin America, territory
identifier: Lat
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
819 |
S-1 |
ISO8859-1 |
3 |
Code page 819, Generic (SYSTEM_819) |
- |
AIX |
850 |
S-1 |
IBM-850 |
3 |
Code page 850, Generic (SYSTEM_850) |
- |
AIX |
923 |
S-1 |
ISO8859-15 |
3 |
Code page 923, Generic (SYSTEM_923) |
- |
AIX |
1208 |
N-1 |
UTF-8 |
3 |
|
- |
AIX |
284 |
S-1 |
IBM-284 |
3 |
|
- |
Host |
1145 |
S-1 |
IBM-1145 |
3 |
|
- |
Host |
819 |
S-1 |
iso88591 |
3 |
Code page 819, Generic (SYSTEM_819) |
- |
- |
923 |
S-1 |
iso885915 |
3 |
Code page 923, Generic (SYSTEM_923) |
- |
- |
1051 |
S-1 |
roman8 |
3 |
Code page 1051, Generic (SYSTEM_1051) |
- |
- |
819 |
S-1 |
ISO-8859-1 |
3 |
Code page 819, Generic (SYSTEM_819) |
- |
Linux |
923 |
S-1 |
ISO-8859-15 |
3 |
Code page 923, Generic (SYSTEM_923) |
- |
Linux |
437 |
S-1 |
IBM-437 |
3 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
850 |
S-1 |
IBM-850 |
3 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
1252 |
S-1 |
1252 |
3 |
Code page 1252, Generic (SYSTEM_1252) |
- |
Windows |
The following map to Latin America (Lat):
- Spanish (Mexican)
- Spanish (Guatemala)
- Spanish (Costa Rica)
- Spanish (Panama)
- Spanish (Dominican Republic)
- Spanish (Venezuela)
- Spanish (Colombia)
- Spanish (Peru)
- Spanish (Argentina)
- Spanish (Ecuador)
- Spanish (Chile)
- Spanish (Uruguay)
- Spanish (Paraguay)
- Spanish (Bolivia)
- Spanish (El Salvador)
- Spanish (Honduras)
- Spanish (Nicaragua)
- Spanish (Puerto Rico)
Table 43. Malta, territory
identifier: MT
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
1208 |
N-1 |
UTF-8 |
356 |
|
- |
- |
Table 45. Nepal, territory identifier: NP
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
806 |
S-13 |
IBM-806 |
977 |
Code page 806, Generic (SYSTEM_806) |
- |
- |
1137 |
S-13 |
IBM-1137 |
977 |
|
|
Host |
1208 |
N-1 |
UTF-8 |
977 |
|
- |
- |
Table 46. Netherlands, territory
identifier: NL
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
819 |
S-1 |
ISO8859-1 |
31 |
Code page 819, Generic (SYSTEM_819) |
nl_NL |
AIX |
850 |
S-1 |
IBM-850 |
31 |
Code page 850, Generic (SYSTEM_850) |
Nl_NL |
AIX |
923 |
S-1 |
ISO8859-15 |
31 |
Code page 923, Generic (SYSTEM_923) |
nl_NL.8859-15 |
AIX |
1208 |
N-1 |
UTF-8 |
31 |
|
NL_NL |
AIX |
37 |
S-1 |
IBM-37 |
31 |
|
- |
Host |
1140 |
S-1 |
IBM-1140 |
31 |
|
- |
Host |
819 |
S-1 |
iso88591 |
31 |
Code page 819, Generic (SYSTEM_819) |
nl_NL.iso88591 |
- |
923 |
S-1 |
iso885915 |
31 |
Code page 923, Generic (SYSTEM_923) |
_ |
- |
1051 |
S-1 |
roman8 |
31 |
Code page 1051, Generic (SYSTEM_1051) |
nl_NL.roman8 |
- |
819 |
S-1 |
ISO-8859-1 |
31 |
Code page 819, Generic (SYSTEM_819) |
nl_NL |
Linux |
923 |
S-1 |
ISO-8859-15 |
31 |
Code page 923, Generic (SYSTEM_923) |
nl_NL@euro |
Linux |
437 |
S-1 |
IBM-437 |
31 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
850 |
S-1 |
IBM-850 |
31 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
819 |
S-1 |
ISO8859-1 |
31 |
Code page 819, Generic (SYSTEM_819) |
nl |
- |
819 |
S-1 |
ISO8859-1 |
31 |
Code page 819, Generic (SYSTEM_819) |
nl_NL |
- |
1252 |
S-1 |
1252 |
31 |
Code page 1252, Generic (SYSTEM_1252) |
- |
Windows |
Table 47. New Zealand, territory
identifier: NZ
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
437 |
S-1 |
IBM-437 |
64 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
1051 |
S-1 |
roman8 |
64 |
Code page 1051, Generic (SYSTEM_1051) |
- |
- |
819 |
S-1 |
ISO8859-1 |
64 |
Code page 819, Generic (SYSTEM_819) |
- |
AIX |
850 |
S-1 |
IBM-850 |
64 |
Code page 850, Generic (SYSTEM_850) |
- |
AIX |
923 |
S-1 |
ISO8859-15 |
64 |
Code page 923, Generic (SYSTEM_923) |
- |
AIX |
1208 |
N-1 |
UTF-8 |
64 |
|
- |
AIX |
37 |
S-1 |
IBM-37 |
64 |
|
- |
Host |
1140 |
S-1 |
IBM-1140 |
64 |
|
- |
Host |
819 |
S-1 |
ISO8859-1 |
64 |
Code page 819, Generic (SYSTEM_819) |
- |
- |
923 |
S-1 |
ISO8859-15 |
64 |
Code page 923, Generic (SYSTEM_923) |
- |
- |
850 |
S-1 |
IBM-850 |
64 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
819 |
S-1 |
ISO8859-1 |
64 |
Code page 819, Generic (SYSTEM_819) |
en_NZ |
- |
1252 |
S-1 |
1252 |
64 |
Code page 1252, Generic (SYSTEM_1252) |
- |
Windows |
Table 48. Nigeria, territory identifier: NG
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
1208 |
N-1 |
UTF-8 |
234 |
|
- |
- |
Table 49. Norway, territory
identifier: NO
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
437 |
S-1 |
IBM-437 |
47 |
Code page 437, Norway (SYSTEM_437_NO) |
- |
- |
819 |
S-1 |
ISO8859-1 |
47 |
Code page 819, Norway (SYSTEM_819_NO) |
no_NO |
AIX |
850 |
S-1 |
IBM-850 |
47 |
Code page 850, Norway (SYSTEM_850_NO) |
No_NO |
AIX |
923 |
S-1 |
ISO8859-15 |
47 |
Code page 923, Norway (SYSTEM_923_NO) |
no_NO.8859-15 |
AIX |
1208 |
N-1 |
UTF-8 |
47 |
|
NO_NO |
AIX |
277 |
S-1 |
IBM-277 |
47 |
|
- |
Host |
1142 |
S-1 |
IBM-1142 |
47 |
|
- |
Host |
819 |
S-1 |
iso88591 |
47 |
Code page 819, Norway (SYSTEM_819_NO) |
no_NO.iso88591 |
- |
923 |
S-1 |
iso885915 |
47 |
Code page 923, Norway (SYSTEM_923_NO) |
- |
- |
1051 |
S-1 |
roman8 |
47 |
Code page 1051, Norway (SYSTEM_1051_NO) |
no_NO.roman8 |
- |
819 |
S-1 |
ISO-8859-1 |
47 |
Code page 819, Norway (SYSTEM_819_NO) |
no_NO |
Linux |
923 |
S-1 |
ISO-8859-15 |
47 |
Code page 923, Norway (SYSTEM_923_NO) |
- |
Linux |
850 |
S-1 |
IBM-850 |
47 |
Code page 850, Norway (SYSTEM_850_NO) |
- |
- |
819 |
S-1 |
ISO8859-1 |
47 |
Code page 819, Norway (SYSTEM_819_NO) |
no |
- |
819 |
S-1 |
ISO8859-1 |
47 |
Code page 819, Norway (SYSTEM_819_NO) |
no_NO |
- |
1252 |
S-1 |
1252 |
47 |
Code page 1252, Norway (SYSTEM_1252_NO) |
- |
Windows |
Table 50. Pakistan, territory
identifier: PK
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
1208 |
N-1 |
UTF-8 |
92 |
|
- |
- |
Table 53. Portugal, territory
identifier: PT
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
437 |
S-1 |
IBM-437 |
351 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
819 |
S-1 |
ISO8859-1 |
351 |
Code page 819, Generic (SYSTEM_819) |
pt_PT |
AIX |
850 |
S-1 |
IBM-850 |
351 |
Code page 850, Generic (SYSTEM_850) |
Pt_PT |
AIX |
923 |
S-1 |
ISO8859-15 |
351 |
Code page 923, Generic (SYSTEM_923) |
pt_PT.8859-15 |
AIX |
1208 |
N-1 |
UTF-8 |
351 |
|
PT_PT |
AIX |
37 |
S-1 |
IBM-37 |
351 |
|
- |
Host |
1140 |
S-1 |
IBM-1140 |
351 |
|
- |
Host |
819 |
S-1 |
iso88591 |
351 |
Code page 819, Generic (SYSTEM_819) |
pt_PT.iso88591 |
- |
923 |
S-1 |
iso885915 |
351 |
Code page 923, Generic (SYSTEM_923) |
- |
- |
1051 |
S-1 |
roman8 |
351 |
Code page 1051, Generic (SYSTEM_1051) |
pt_PT.roman8 |
- |
819 |
S-1 |
ISO-8859-1 |
351 |
Code page 819, Generic (SYSTEM_819) |
pt_PT |
Linux |
923 |
S-1 |
ISO-8859-15 |
351 |
Code page 923, Generic (SYSTEM_923) |
pt_PT@euro |
Linux |
850 |
S-1 |
IBM-850 |
351 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
860 |
S-1 |
IBM-860 |
351 |
Code page 860, Generic (SYSTEM_860) |
- |
- |
819 |
S-1 |
ISO8859-1 |
351 |
Code page 819, Generic (SYSTEM_819) |
pt |
- |
819 |
S-1 |
ISO8859-1 |
351 |
Code page 819, Generic (SYSTEM_819) |
pt_PT |
- |
1252 |
S-1 |
1252 |
351 |
Code page 1252, Generic (SYSTEM_1252) |
- |
Windows |
Table 57. Senegal, territory identifier: SN
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
1208 |
N-1 |
UTF-8 |
221 |
|
- |
- |
Table 59. Serbia/Montenegro,
territory identifier: SP. Note: This table has been deprecated.
Refer to
Table 44 (Montenegro,
territory identifier: ME) and
Table 58 (Serbia,
territory identifier: RS).
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
852 |
S-2 |
IBM-852 |
381 |
Code page 852, Generic (SYSTEM_852) |
- |
- |
912 |
S-2 |
ISO8859-2 |
381 |
Code page 912, Generic (SYSTEM_912) |
- |
- |
1250 |
S-2 |
1250 |
381 |
Code page 1250, Generic (SYSTEM_1250) |
- |
- |
915 |
S-5 |
ISO8859-5 |
381 |
Code page 915, Generic (SYSTEM_915) |
sr_SP |
AIX |
1208 |
N-1 |
UTF-8 |
381 |
|
SR_SP |
AIX |
1025 |
S-5 |
IBM-1025 |
381 |
|
- |
Host |
1154 |
S-5 |
IBM-1154 |
381 |
|
- |
Host |
915 |
S-5 |
iso88595 |
381 |
Code page 915, Generic (SYSTEM_915) |
- |
- |
855 |
S-5 |
IBM-855 |
381 |
Code page 855, Generic (SYSTEM_855) |
- |
- |
915 |
S-5 |
ISO8859-5 |
381 |
Code page 915, Generic (SYSTEM_915) |
- |
- |
1251 |
S-5 |
1251 |
381 |
Code page 1251, Generic (SYSTEM_1251) |
- |
Windows |
Table 62. South Africa, territory
identifier: ZA
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
819 |
S-1 |
ISO8859-1 |
27 |
Code page 819, Generic (SYSTEM_819) |
en_ZA |
AIX |
850 |
S-1 |
IBM-850 |
27 |
Code page 850, Generic (SYSTEM_850) |
En_ZA |
AIX |
923 |
S-1 |
ISO8859-15 |
27 |
Code page 923, Generic (SYSTEM_923) |
en_ZA.8859-15 |
AIX |
1208 |
N-1 |
UTF-8 |
27 |
|
EN_ZA |
AIX |
285 |
S-1 |
IBM-285 |
27 |
|
- |
Host |
1146 |
S-1 |
IBM-1146 |
27 |
|
- |
Host |
819 |
S-1 |
iso88591 |
27 |
Code page 819, Generic (SYSTEM_819) |
- |
- |
923 |
S-1 |
iso885915 |
27 |
Code page 923, Generic (SYSTEM_923) |
- |
- |
1051 |
S-1 |
roman8 |
27 |
Code page 1051, Generic (SYSTEM_1051) |
- |
- |
437 |
S-1 |
IBM-437 |
27 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
850 |
S-1 |
IBM-850 |
27 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
819 |
S-1 |
ISO8859-1 |
27 |
Code page 819, Generic (SYSTEM_819) |
en_ZA.ISO8859-1 |
- |
1252 |
S-1 |
1252 |
27 |
Code page 1252, Generic (SYSTEM_1252) |
- |
Windows |
Table 63. Spain, territory
identifier: ES
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
819 |
S-1 |
ISO8859-1 |
34 |
Code page 819, Generic (SYSTEM_819) |
es_ES |
AIX |
850 |
S-1 |
IBM-850 |
34 |
Code page 850, Generic (SYSTEM_850) |
Es_ES |
AIX |
923 |
S-1 |
ISO8859-15 |
34 |
Code page 923, Generic (SYSTEM_923) |
es_ES.8859-15 |
AIX |
1208 |
N-1 |
UTF-8 |
34 |
|
ES_ES |
AIX |
284 |
S-1 |
IBM-284 |
34 |
|
- |
Host |
1145 |
S-1 |
IBM-1145 |
34 |
|
- |
Host |
819 |
S-1 |
iso88591 |
34 |
Code page 819, Generic (SYSTEM_819) |
es_ES.iso88591 |
- |
923 |
S-1 |
iso885915 |
34 |
Code page 923, Generic (SYSTEM_923) |
- |
- |
1051 |
S-1 |
roman8 |
34 |
Code page 1051, Generic (SYSTEM_1051) |
es_ES.roman8 |
- |
819 |
S-1 |
ISO-8859-1 |
34 |
Code page 819, Generic (SYSTEM_819) |
es_ES |
Linux |
923 |
S-1 |
ISO-8859-15 |
34 |
Code page 923, Generic (SYSTEM_923) |
es_ES@euro |
Linux |
437 |
S-1 |
IBM-437 |
34 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
850 |
S-1 |
IBM-850 |
34 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
819 |
S-1 |
ISO8859-1 |
34 |
Code page 819, Generic (SYSTEM_819) |
es |
- |
819 |
S-1 |
ISO8859-1 |
34 |
Code page 819, Generic (SYSTEM_819) |
es_ES |
- |
1252 |
S-1 |
1252 |
34 |
Code page 1252, Generic (SYSTEM_1252) |
- |
Windows |
Table 65. Sri Lanka, territory identifier: LK
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
1208 |
N-1 |
UTF-8 |
94 |
|
- |
- |
Table 66. Sweden, territory
identifier: SE
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
819 |
S-1 |
ISO8859-1 |
46 |
Code page 819, Finland and Sweden (SYSTEM_819_FI and SYSTEM_819_SE) |
sv_SE |
AIX |
850 |
S-1 |
IBM-850 |
46 |
Code page 850, Finland and Sweden (SYSTEM_850_FI and SYSTEM_850_SE) |
Sv_SE |
AIX |
923 |
S-1 |
ISO8859-15 |
46 |
Code page 923, Finland and Sweden (SYSTEM_923_FI and SYSTEM_923_SE) |
sv_SE.8859-15 |
AIX |
1208 |
N-1 |
UTF-8 |
46 |
|
SV_SE |
AIX |
278 |
S-1 |
IBM-278 |
46 |
|
- |
Host |
1143 |
S-1 |
IBM-1143 |
46 |
|
- |
Host |
819 |
S-1 |
iso88591 |
46 |
Code page 819, Finland and Sweden (SYSTEM_819_FI and SYSTEM_819_SE) |
sv_SE.iso88591 |
- |
923 |
S-1 |
iso885915 |
46 |
Code page 923, Finland and Sweden (SYSTEM_923_FI and SYSTEM_923_SE) |
- |
- |
1051 |
S-1 |
roman8 |
46 |
Code page 1051, Finland and Sweden (SYSTEM_1051_FI and SYSTEM_1051_SE) |
sv_SE.roman8 |
- |
819 |
S-1 |
ISO-8859-1 |
46 |
Code page 819, Finland and Sweden (SYSTEM_819_FI and SYSTEM_819_SE) |
sv_SE |
Linux |
923 |
S-1 |
ISO-8859-15 |
46 |
Code page 923, Finland and Sweden (SYSTEM_923_FI and SYSTEM_923_SE) |
- |
Linux |
437 |
S-1 |
IBM-437 |
46 |
Code page 437, Finland and Sweden (SYSTEM_437_FI and SYSTEM_437_SE) |
- |
- |
850 |
S-1 |
IBM-850 |
46 |
Code page 850, Finland and Sweden (SYSTEM_850_FI and SYSTEM_850_SE) |
- |
- |
819 |
S-1 |
ISO8859-1 |
46 |
Code page 819, Finland and Sweden (SYSTEM_819_FI and SYSTEM_819_SE) |
sv |
- |
819 |
S-1 |
ISO8859-1 |
46 |
Code page 819, Finland and Sweden (SYSTEM_819_FI and SYSTEM_819_SE) |
sv_SE |
- |
1252 |
S-1 |
1252 |
46 |
Code page 1252, Finland and Sweden (SYSTEM_1252_FI and SYSTEM_1252_SE) |
- |
Windows |
Table 67. Switzerland, territory
identifier: CH
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
819 |
S-1 |
ISO8859-1 |
41 |
Code page 819, Generic (SYSTEM_819) |
de_CH |
AIX |
850 |
S-1 |
IBM-850 |
41 |
Code page 850, Generic (SYSTEM_850) |
De_CH |
AIX |
923 |
S-1 |
ISO8859-15 |
41 |
Code page 923, Generic (SYSTEM_923) |
de_CH.8859-15 |
AIX |
1208 |
N-1 |
UTF-8 |
41 |
|
DE_CH |
AIX |
500 |
S-1 |
IBM-500 |
41 |
|
- |
Host |
1148 |
S-1 |
IBM-1148 |
41 |
|
- |
Host |
819 |
S-1 |
iso88591 |
41 |
Code page 819, Generic (SYSTEM_819) |
- |
- |
923 |
S-1 |
iso885915 |
41 |
Code page 923, Generic (SYSTEM_923) |
- |
- |
1051 |
S-1 |
roman8 |
41 |
Code page 1051, Generic (SYSTEM_1051) |
- |
- |
819 |
S-1 |
ISO-8859-1 |
41 |
Code page 819, Generic (SYSTEM_819) |
de_CH |
Linux |
923 |
S-1 |
ISO-8859-15 |
41 |
Code page 923, Generic (SYSTEM_923) |
- |
Linux |
437 |
S-1 |
IBM-437 |
41 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
850 |
S-1 |
IBM-850 |
41 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
819 |
S-1 |
ISO8859-1 |
41 |
Code page 819, Generic (SYSTEM_819) |
de_CH |
- |
819 |
S-1 |
ISO8859-1 |
41 |
Code page 819, Generic (SYSTEM_819) |
fr_CH |
- |
819 |
S-1 |
ISO8859-1 |
41 |
Code page 819, Generic (SYSTEM_819) |
it_CH |
- |
1252 |
S-1 |
1252 |
41 |
Code page 1252, Generic (SYSTEM_1252) |
- |
Windows |
Table 68. Taiwan, territory
identifier: TW
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
437 |
S-1 |
IBM-437 |
88 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
819 |
S-1 |
ISO8859-1 |
88 |
Code page 819, Generic (SYSTEM_819) |
- |
- |
850 |
S-1 |
IBM-850 |
88 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
923 |
S-1 |
ISO8859-15 |
88 |
Code page 923, Generic (SYSTEM_923) |
- |
- |
1051 |
S-1 |
roman8 |
88 |
Code page 1051, Generic (SYSTEM_1051) |
- |
- |
950 |
D-2 |
big5 |
88 |
Code page 950, Generic (SYSTEM_950) |
Zh_TW |
AIX |
See note 5. |
964 |
D-2 |
IBM-eucTW |
88 |
Code page 964, Generic (SYSTEM_964) |
zh_TW |
AIX |
1208 |
N-1 |
UTF-8 |
88 |
|
ZH_TW |
AIX |
937 |
D-2 |
IBM-937 |
88 |
|
- |
Host |
1371 |
D-2 |
IBM-1371 |
88 |
|
- |
Host |
950 |
D-2 |
big5 |
88 |
Code page 950, Generic (SYSTEM_950) |
zh_TW.big5 |
- |
964 |
D-2 |
eucTW |
88 |
Code page 964, Generic (SYSTEM_964) |
zh_TW.eucTW |
- |
950 |
D-2 |
BIG5 |
88 |
Code page 950, Generic (SYSTEM_950) |
zh_TW |
Linux |
938 |
D-2 |
IBM-938 |
88 |
Code page 938, Generic (SYSTEM_938) |
- |
- |
948 |
D-2 |
IBM-948 |
88 |
Code page 948, Generic (SYSTEM_948) |
- |
- |
950 |
D-2 |
big5 |
88 |
Code page 950, Generic (SYSTEM_950) |
- |
- |
950 |
D-2 |
big5 |
88 |
Code page 950, Generic (SYSTEM_950) |
- |
Windows |
See note 5. |
Table 72. Uganda, territory identifier: UG
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
1208 |
N-1 |
UTF-8 |
256 |
|
- |
- |
Table 73. United Kingdom,
territory identifier: GB
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
819 |
S-1 |
ISO8859-1 |
44 |
Code page 819, Generic (SYSTEM_819) |
en_GB |
AIX |
850 |
S-1 |
IBM-850 |
44 |
Code page 850, Generic (SYSTEM_850) |
En_GB |
AIX |
923 |
S-1 |
ISO8859-15 |
44 |
Code page 923, Generic (SYSTEM_923) |
en_GB.8859-15 |
AIX |
1208 |
N-1 |
UTF-8 |
44 |
|
EN_GB |
AIX |
285 |
S-1 |
IBM-285 |
44 |
|
- |
Host |
1146 |
S-1 |
IBM-1146 |
44 |
|
- |
Host |
819 |
S-1 |
iso88591 |
44 |
Code page 819, Generic (SYSTEM_819) |
en_GB.iso88591 |
- |
923 |
S-1 |
iso885915 |
44 |
Code page 923, Generic (SYSTEM_923) |
- |
- |
1051 |
S-1 |
roman8 |
44 |
Code page 1051, Generic (SYSTEM_1051) |
en_GB.roman8 |
- |
819 |
S-1 |
ISO-8859-1 |
44 |
Code page 819, Generic (SYSTEM_819) |
en_GB |
Linux |
923 |
S-1 |
ISO-8859-15 |
44 |
Code page 923, Generic (SYSTEM_923) |
- |
Linux |
437 |
S-1 |
IBM-437 |
44 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
850 |
S-1 |
IBM-850 |
44 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
819 |
S-1 |
ISO8859-1 |
44 |
Code page 819, Generic (SYSTEM_819) |
en_GB |
- |
819 |
S-1 |
ISO8859-1 |
44 |
Code page 819, Generic (SYSTEM_819) |
en |
- |
1252 |
S-1 |
1252 |
44 |
Code page 1252, Generic (SYSTEM_1252) |
- |
Windows |
Table 75. United States of
America, territory identifier: US
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
819 |
S-1 |
ISO8859-1 |
1 |
Code page 819, Generic (SYSTEM_819) |
en_US |
AIX |
850 |
S-1 |
IBM-850 |
1 |
Code page 850, Generic (SYSTEM_850) |
En_US |
AIX |
923 |
S-1 |
ISO8859-15 |
1 |
Code page 923, Generic (SYSTEM_923) |
en_US.8859-15 |
AIX |
1208 |
N-1 |
UTF-8 |
1 |
|
EN_US |
AIX |
37 |
S-1 |
IBM-37 |
1 |
|
- |
Host |
1140 |
S-1 |
IBM-1140 |
1 |
|
- |
Host |
819 |
S-1 |
iso88591 |
1 |
Code page 819, Generic (SYSTEM_819) |
en_US.iso88591 |
- |
923 |
S-1 |
iso885915 |
1 |
Code page 923, Generic (SYSTEM_923) |
- |
- |
1051 |
S-1 |
roman8 |
1 |
Code page 1051, Generic (SYSTEM_1051) |
en_US.roman8 |
- |
819 |
S-1 |
ISO-8859-1 |
1 |
Code page 819, Generic (SYSTEM_819) |
en_US |
Linux |
923 |
S-1 |
ISO-8859-15 |
1 |
Code page 923, Generic (SYSTEM_923) |
- |
Linux |
437 |
S-1 |
IBM-437 |
1 |
Code page 437, Generic (SYSTEM_437) |
- |
- |
850 |
S-1 |
IBM-850 |
1 |
Code page 850, Generic (SYSTEM_850) |
- |
- |
819 |
S-1 |
ISO8859-1 |
1 |
Code page 819, Generic (SYSTEM_819) |
en_US |
- |
1252 |
S-1 |
1252 |
1 |
Code page 1252, Generic (SYSTEM_1252) |
- |
Windows |
Table 76. Uzbekistan, territory identifier: UZ
Code page |
Group |
Code set |
Territory code |
Collation |
Locale |
Operating system |
1208 |
N-1 |
UTF-8 |
998 |
|
- |
- |
Note:
- On AIX 4.3 or
later the code page is 943. If you are using AIX 4.2 or earlier, the code page is 932.
- Code page 1394 (Shift JIS X0213) can only be used with the load or import utilities
to move data from code page 1394 to a Db2 Unicode database, or
to export from a Db2 Unicode database to
code page 1394.
- The following map to English (US):
- English (Jamaica)
- English (Caribbean)
- English (Singapore)
Code page 5488 is equivalent to
1392.
Starting with Version 9.7 Fix Pack 1, only SYSTEM and IDENTITY collations
can be specified for a 1392 code page database. For SYSTEM collation,
only a subset of characters are assigned weight values used for ordering.
These weight values are equivalent to a 1386 database with the SYSTEM collation.
All other characters are sorted in a binary order. Graphic strings
are not supported in a 1392 database.
- Code page 950 is also known as Big5. Microsoft code page 950 differs from IBM code page 950
in the following ways:
Range |
Description |
IBM |
Microsoft |
Difference |
X'8140' to X'8DFE' |
User-defined characters |
User-defined area |
User-defined area |
Same |
X'8E40' to X'A0FE' |
User-defined characters |
User-defined area |
User-defined area |
Same |
X'A140' to X'A3BF' |
Special symbols |
System characters |
System characters |
Same |
X'A3C0' to X'A3E0' |
Control symbols |
System characters |
Empty |
Different |
X'A3E1' to X'A3FE' |
Reserved |
Empty |
Empty |
Same |
X'A440' to X'C67E' |
Primary use characters |
System characters |
System characters |
Same |
X'C6A1' to X'C878' |
Eten added symbols |
System characters |
User-defined area |
Different |
X'C879' to X'C8CC' |
Eten added symbols |
Empty |
User-defined area |
Different |
X'C8CD' to X'C8D3' |
Eten added symbols |
System characters |
User-defined area |
Different |
X'C8D4' to X'C8FD' |
Reserved |
System characters |
User-defined area |
Different |
X'C8FE' |
Invalid/ undefined character |
System characters |
User-defined area |
Different |
X'C940' to X'F9D5' |
Secondary use characters |
System characters |
System characters |
Same |
X'F9D6' to X'F9FE' |
Eten extension for Big-5 |
User-defined area |
System characters |
Different |
X'FA40' to X'FEFE' |
User-defined characters |
User-defined area |
User-defined area |
Same |
X'8181' to X'8C82' |
User-defined characters |
User-defined area |
Empty |
Different |
X'F286' to X'F9A0' |
IBM select
characters |
System characters |
Empty |
Different |
Total characters |
|
14 060 |
13 502 |
|
Total user-defined characters |
|
6 204 |
6 217 |
|
Total defined code points |
|
20 264 |
19 719 |
|
- Code page 1375 can be used only on the client. You cannot create a database with
code page 1375. Instead, use a Unicode database to store HKSCS data. Db2 code page conversion
tables support HKSCS-2004. You can also migrate a code page 950 database containing HKSCS data to a
Unicode database. Since a database with code page 1375 cannot be created, a Unicode database cannot
specify the collation SYSTEM_1375_HK.
- File names with characters in the GB18030 code
set but not in the GBK code set are not supported in the deprecated
Control Center. To open or save these files, use CLP commands or CLI.