Table of Contents

Search

  1. Preface
  2. Understanding Domains
  3. Managing Your Account
  4. Using Informatica Administrator
  5. Using the Domain View
  6. Domain Management
  7. Nodes
  8. High Availability
  9. Connections
  10. Connection Properties
  11. Schedules
  12. Domain Object Export and Import
  13. License Management
  14. Monitoring
  15. Log Management
  16. Domain Reports
  17. Node Diagnostics
  18. Understanding Globalization
  19. Appendix A: Code Pages
  20. Appendix B: Custom Roles
  21. Appendix C: Informatica Platform Connectivity
  22. Appendix D: Configure the Web Browser

Administrator Guide

Administrator Guide

Supported Code Pages for Sources and Targets

Supported Code Pages for Sources and Targets

Informatica supports code pages for internationalization. Informatica uses International Components for Unicode (ICU) for its globalization support. For a list of code page aliases in ICU, see http://demo.icu-project.org/icu-bin/convexp.
When you assign a source or target code page in the PowerCenter Client, you select the code page description. When you assign a code page using the
pmrep
CreateConnection command or define a code page in a parameter file, you enter the code page name. The following table lists the name, description, and ID for supported code pages for sources and targets:
Name
Description
ID
Adobe-Standard-Encoding
Adobe Standard Encoding
10073
BOCU-1
Binary Ordered Compression for Unicode (BOCU-1)
10010
CESU-8
ICompatibility Encoding Scheme for UTF-16 (CESU-8)
10011
cp1006
ISO Urdu
10075
cp1098
PC Farsi
10076
cp1124
ISO Cyrillic Ukraine
10077
cp1125
PC Cyrillic Ukraine
10078
cp1131
PC Cyrillic Belarus
10080
cp1381
PC Chinese GB (S-Ch Data mixed)
10082
cp850
PC Latin1
10036
cp851
PC DOS Greek (without euro)
10037
cp856
PC Hebrew (old)
10040
cp857
PC Latin5 (without euro update)
10041
cp858
PC Latin1 (with euro update)
10042
cp860
PC Portugal
10043
cp861
PC Iceland
10044
cp862
PC Hebrew (without euro update)
10045
cp863
PC Canadian French
10046
cp864
PC Arabic (without euro update)
10047
cp865
PC Nordic
10048
cp866
PC Russian (without euro update)
10049
cp868
PC Urdu
10051
cp869
PC Greek (without euro update)
10052
cp922
IPC Estonian (without euro update)
10056
cp949c
PC Korea - KS
10028
ebcdic-xml-us
EBCDIC US (with euro) - Extension for XML4C(Xerces)
10180
EUC-KR
EUC Korean
10029
GB_2312-80
Simplified Chinese (GB2312-80)
10025
gb18030
GB 18030 MBCS codepage
1392
GB2312
Chinese EUC
10024
HKSCS
Hong Kong Supplementary Character Set
9200
hp-roman8
HP Latin1
10072
HZ-GB-2312
Simplified Chinese (HZ GB2312)
10092
IBM037
IBM EBCDIC US English
2028
IBM-1025
EBCDIC Cyrillic
10127
IBM1026
EBCDIC Turkey
10128
IBM1047
IBM EBCDIC US English IBM1047
1047
IBM-1047-s390
EBCDIC IBM-1047 for S/390 (lf and nl swapped)
10167
IBM-1097
EBCDIC Farsi
10129
IBM-1112
EBCDIC Baltic
10130
IBM-1122
EBCDIC Estonia
10131
IBM-1123
EBCDIC Cyrillic Ukraine
10132
IBM-1129
ISO Vietnamese
10079
IBM-1130
EBCDIC Vietnamese
10133
IBM-1132
EBCDIC Lao
10134
IBM-1133
ISO Lao
10081
IBM-1137
EBCDIC Devanagari
10163
IBM-1140
EBCDIC US (with euro update)
10135
IBM-1140-s390
EBCDIC IBM-1140 for S/390 (lf and nl swapped)
10168
IBM-1141
EBCDIC Germany, Austria (with euro update)
10136
IBM-1142
EBCDIC Denmark, Norway (with euro update)
10137
IBM-1142-s390
EBCDIC IBM-1142 for S/390 (lf and nl swapped)
10169
IBM-1143
EBCDIC Finland, Sweden (with euro update)
10138
IBM-1143-s390
EBCDIC IBM-1143 for S/390 (lf and nl swapped)
10170
IBM-1144
EBCDIC Italy (with euro update)
10139
IBM-1144-s390
EBCDIC IBM-1144 for S/390 (lf and nl swapped)
10171
IBM-1145
EBCDIC Spain, Latin America (with euro update)
10140
IBM-1145-s390
EBCDIC IBM-1145 for S/390 (lf and nl swapped)
10172
IBM-1146
EBCDIC UK, Ireland (with euro update)
10141
IBM-1146-s390
EBCDIC IBM-1146 for S/390 (lf and nl swapped)
10173
IBM-1147
EBCDIC French (with euro update)
10142
IBM-1147-s390
EBCDIC IBM-1147 for S/390 (lf and nl swapped)
10174
IBM-1147-s390
EBCDIC IBM-1147 for S/390 (lf and nl swapped)
10174
IBM-1148
EBCDIC International Latin1 (with euro update)
10143
IBM-1148-s390
EBCDIC IBM-1148 for S/390 (lf and nl swapped)
10175
IBM-1149
EBCDIC Iceland (with euro update)
10144
IBM-1149-s390
IEBCDIC IBM-1149 for S/390 (lf and nl swapped)
10176
IBM-1153
EBCDIC Latin2 (with euro update)
10145
IBM-1153-s390
EBCDIC IBM-1153 for S/390 (lf and nl swapped)
10177
IBM-1154
EBCDIC Cyrillic Multilingual (with euro update)
10146
IBM-1155
EBCDIC Turkey (with euro update)
10147
IBM-1156
EBCDIC Baltic Multilingual (with euro update)
10148
IBM-1157
EBCDIC Estonia (with euro update)
10149
IBM-1158
EBCDIC Cyrillic Ukraine (with euro update)
10150
IBM1159
IBM EBCDIC Taiwan, Traditional Chinese
11001
IBM-1160
EBCDIC Thai (with euro update)
10151
IBM-1162
Thai (with euro update)
10033
IBM-1164
EBCDIC Vietnamese (with euro update)
10152
IBM-1250
MS Windows Latin2 (without euro update)
10058
IBM-1251
MS Windows Cyrillic (without euro update)
10059
IBM-1255
MS Windows Hebrew (without euro update)
10060
IBM-1256
MS Windows Arabic (without euro update)
10062
IBM-1257
MS Windows Baltic (without euro update)
10064
IBM-1258
MS Windows Vietnamese (without euro update)
10066
IBM-12712
EBCDIC Hebrew (updated with euro and new sheqel, control characters)
10161
IBM-12712-s390
EBCDIC IBM-12712 for S/390 (lf and nl swapped)
10178
IBM-1277
Adobe Latin1 Encoding
10074
IBM13121
IBM EBCDIC Korean Extended CP13121
11002
IBM13124
IBM EBCDIC Simplified Chinese CP13124
11003
IBM-1363
PC Korean KSC MBCS Extended (with \ <-> Won mapping)
10032
IBM-1364
EBCDIC Korean Extended (SBCS IBM-13121 combined with DBCS IBM-4930)
10153
IBM-1371
EBCDIC Taiwan Extended (SBCS IBM-1159 combined with DBCS IBM-9027)
10154
IBM-1373
Taiwan Big-5 (with euro update)
10019
IBM-1375
MS Taiwan Big-5 with HKSCS extensions
10022
IBM-1386
PC Chinese GBK (IBM-1386)
10023
IBM-1388
EBCDIC Chinese GB (S-Ch DBCS-Host Data)
10155
IBM-1390
EBCDIC Japanese Katakana (with euro)
10156
IBM-1399
EBCDIC Japanese Latin-Kanji (with euro)
10157
IBM-16684
EBCDIC Japanese Extended (DBCS IBM-1390 combined with DBCS IBM-1399)
10158
IBM-16804
EBCDIC Arabic (with euro update)
10162
IBM-16804-s390
EBCDIC IBM-16804 for S/390 (lf and nl swapped)
10179
IBM-25546
ISO-2022 encoding for Korean (extension 1)
10089
IBM273
IBM EBCDIC German
2030
IBM277
EBCDIC Denmark, Norway
10115
IBM278
EBCDIC Finland, Sweden
10116
IBM280
IBM EBCDIC Italian
2035
IBM284
EBCDIC Spain, Latin America
10117
IBM285
IBM EBCDIC UK English
2038
IBM290
EBCDIC Japanese Katakana SBCS
10118
IBM297
IBM EBCDIC French
2040
IBM-33722
Japanese EUC (with \ <-> Yen mapping)
10017
IBM367
IBM367
10012
IBM-37-s390
EBCDIC IBM-37 for S/390 (lf and nl swapped)
10166
IBM420
EBCDIC Arabic
10119
IBM424
EBCDIC Hebrew (updated with new sheqel, control characters)
10120
IBM437
PC United States
10035
IBM-4899
EBCDIC Hebrew (with euro)
10159
IBM-4909
ISO Greek (with euro update)
10057
IBM4933
IBM Simplified Chinese CP4933
11004
IBM-4971
EBCDIC Greek (with euro update)
10160
IBM500
IBM EBCDIC International Latin-1
2044
IBM-5050
Japanese EUC (Packed Format)
10018
IBM-5123
EBCDIC Japanese Latin (with euro update)
10164
IBM-5351
MS Windows Hebrew (older version)
10061
IBM-5352
MS Windows Arabic (older version)
10063
IBM-5353
MS Windows Baltic (older version)
10065
IBM-803
EBCDIC Hebrew
10121
IBM833
IBM EBCDIC Korean CP833
833
IBM834
IBM EBCDIC Korean CP834
834
IBM835
IBM Taiwan, Traditional Chinese CP835
11005
IBM836
IBM EBCDIC Simplified Chinese Extended
11006
IBM837
IBM Simplified Chinese CP837
11007
IBM-838
EBCDIC Thai
10122
IBM-8482
EBCDIC Japanese Katakana SBCS (with euro update)
10165
IBM852
PC Latin2 (without euro update)
10038
IBM855
PC Cyrillic (without euro update)
10039
IBM-867
PC Hebrew (with euro update)
10050
IBM870
EBCDIC Latin2
10123
IBM871
EBCDIC Iceland
10124
IBM-874
PC Thai (without euro update)
10034
IBM-875
EBCDIC Greek
10125
IBM-901
PC Baltic (with euro update)
10054
IBM-902
PC Estonian (with euro update)
10055
IBM918
EBCDIC Urdu
10126
IBM930
IBM EBCDIC Japanese
930
IBM933
IBM EBCDIC Korean CP933
933
IBM935
IBM EBCDIC Simplified Chinese
935
IBM937
IBM EBCDIC Traditional Chinese
937
IBM939
IBM EBCDIC Japanese CP939
939
IBM-942
PC Japanese SJIS-78 syntax (IBM-942)
10015
IBM-943
PC Japanese SJIS-90 (IBM-943)
10016
IBM-949
PC Korea - KS (default)
10027
IBM-950
Taiwan Big-5 (without euro update)
10020
IBM-964
EUC Taiwan
10026
IBM-971
EUC Korean (DBCS-only)
10030
IMAP-mailbox-name
IMAP Mailbox Name
10008
is-960
Israeli Standard 960 (7-bit Hebrew encoding)
11000
ISO-2022-CN
ISO-2022 encoding for Chinese
10090
ISO-2022-CN-EXT
ISO-2022 encoding for Chinese (extension 1)
10091
ISO-2022-JP
ISO-2022 encoding for Japanese
10083
ISO-2022-JP-2
ISO-2022 encoding for Japanese (extension 2)
10085
ISO-2022-KR
ISO-2022 encoding for Korean
10088
ISO-8859-10
ISO 8859-10 Latin 6 (Nordic)
13
ISO-8859-13
ISO 8859-13 PC Baltic (without euro update)
10014
ISO-8859-15
ISO 8859-15 Latin 9 (Western European)
201
ISO-8859-2
ISO 8859-2 Eastern European
5
ISO-8859-3
ISO 8859-3 Southeast European
6
ISO-8859-4
ISO 8859-4 Baltic
7
ISO-8859-5
ISO 8859-5 Cyrillic
8
ISO-8859-6
ISO 8859-6 Arabic
9
ISO-8859-7
ISO 8859-7 Greek
10
ISO-8859-8
ISO 8859-8 Hebrew
11
ISO-8859-9
ISO 8859-9 Latin 5 (Turkish)
12
JapanEUC
Japanese Extended UNIX Code (including JIS X 0212)
18
JEF
Japanese EBCDIC Fujitsu
9000
JEF-K
Japanese EBCDIC-Kana Fujitsu
9005
JIPSE
NEC ACOS JIPSE Japanese
9002
JIPSE-K
NEC ACOS JIPSE-Kana Japanese
9007
JIS_Encoding
ISO-2022 encoding for Japanese (extension 1)
10084
JIS_X0201
ISO-2022 encoding for Japanese (JIS_X0201)
10093
JIS7
ISO-2022 encoding for Japanese (extension 3)
10086
JIS8
ISO-2022 encoding for Japanese (extension 4)
10087
JP-EBCDIC
EBCDIC Japanese
9010
JP-EBCDIK
EBCDIK Japanese
9011
KEIS
HITACHI KEIS Japanese
9001
KEIS-K
HITACHI KEIS-Kana Japanese
9006
KOI8-R
IRussian Internet
10053
KSC_5601
PC Korean KSC MBCS Extended (KSC_5601)
10031
Latin1
ISO 8859-1 Western European
4
LMBCS-1
Lotus MBCS encoding for PC Latin1
10103
LMBCS-11
Lotus MBCS encoding for MS-DOS Thai
10110
LMBCS-16
Lotus MBCS encoding for Windows Japanese
10111
LMBCS-17
Lotus MBCS encoding for Windows Korean
10112
LMBCS-18
Lotus MBCS encoding for Windows Chinese (Traditional)
10113
LMBCS-19
Lotus MBCS encoding for Windows Chinese (Simplified)
10114
LMBCS-2
Lotus MBCS encoding for PC DOS Greek
10104
LMBCS-3
Lotus MBCS encoding for Windows Hebrew
10105
LMBCS-4
Lotus MBCS encoding for Windows Arabic
10106
LMBCS-5
Lotus MBCS encoding for Windows Cyrillic
10107
LMBCS-6
Lotus MBCS encoding for PC Latin2
10108
LMBCS-8
Lotus MBCS encoding for Windows Turkish
10109
macintosh
Apple Latin 1
10067
MELCOM
MITSUBISHI MELCOM Japanese
9004
MELCOM-K
MITSUBISHI MELCOM-Kana Japanese
9009
MS1250
MS Windows Latin 2 (Central Europe)
2250
MS1251
MS Windows Cyrillic (Slavic)
2251
MS1252
MS Windows Latin 1 (ANSI), superset of Latin1
2252
MS1253
MS Windows Greek
2253
MS1254
MS Windows Latin 5 (Turkish), superset of ISO 8859-9
2254
MS1255
MS Windows Hebrew
2255
MS1256
MS Windows Arabic
2256
MS1257
MS Windows Baltic Rim
2257
MS1258
MS Windows Vietnamese
2258
MS1361
MS Windows Korean (Johab)
1361
MS874
MS-DOS Thai, superset of TIS 620
874
MS932
MS Windows Japanese, Shift-JIS
2024
MS936
MS Windows Simplified Chinese, superset of GB 2312-80, EUC encoding
936
MS949
MS Windows Korean, superset of KS C 5601-1992
949
MS950
MS Windows Traditional Chinese, superset of Big 5
950
SCSU
Standard Compression Scheme for Unicode (SCSU)
10009
UNISYS
UNISYS Japanese
9003
UNISYS-K
UNISYS-Kana Japanese
9008
US-ASCII
7-bit ASCII
1
UTF-16_OppositeEndian
UTF-16 encoding of Unicode (Opposite Platform Endian)
10004
UTF-16_PlatformEndian
UTF-16 encoding of Unicode (Platform Endian)
10003
UTF-16BE
UTF-16 encoding of Unicode (Big Endian)
1200
UTF-16LE
UTF-16 encoding of Unicode (Lower Endian)
1201
UTF-32_OppositeEndian
UTF-32 encoding of Unicode (Opposite Platform Endian)
10006
UTF-32_PlatformEndian
UTF-32 encoding of Unicode (Platform Endian)
10005
UTF-32BE
UTF-32 encoding of Unicode (Big Endian)
10001
UTF-32LE
UTF-32 encoding of Unicode (Lower Endian)
10002
UTF-7
UTF-7 encoding of Unicode
10007
UTF-8
UTF-8 encoding of Unicode
106
windows-57002
Indian Script Code for Information Interchange - Devanagari
10094
windows-57003
Indian Script Code for Information Interchange - Bengali
10095
windows-57004
Indian Script Code for Information Interchange - Tamil
10099
windows-57005
Indian Script Code for Information Interchange - Telugu
10100
windows-57007
Indian Script Code for Information Interchange - Oriya
10098
windows-57008
Indian Script Code for Information Interchange - Kannada
10101
windows-57009
Indian Script Code for Information Interchange - Malayalam
10102
windows-57010
Indian Script Code for Information Interchange - Gujarati
10097
windows-57011
Indian Script Code for Information Interchange - Gurumukhi
10096
x-mac-centraleurroman
Apple Central Europe
10070
x-mac-cyrillic
Apple Cyrillic
10069
x-mac-greek
Apple Greek
10068
x-mac-turkish
Apple Turkish
10071

Restrictions for Code Pages for Sources and Targets

Consider the following restrictions when you assign a source or target code page:
  • Select IBM EBCDIC as your source database connection code page only if you access EBCDIC data, such as data from a mainframe extract file.
  • The following code pages are not supported for database or relational connections:
    • UTF-16 encoding of Unicode (Opposite Platform Endian)
    • UTF-16 encoding of Unicode (Platform Endian)
    • UTF-16 encoding of Unicode (Big Endian)
    • UTF-16 encoding of Unicode (Lower Endian)

0 COMMENTS

We’d like to hear from you!