EBCDIC and ASCII support
DB2® supports both EBCDIC and ASCII encoding of data.
If you specify MIXED DATA = NO on panel DSNTIPF, you can use any compatible SBCS CCSID in the EBCDIC CCSID and ASCII CCSID fields. The first table below lists a selection of common SBCS CCSIDs that might be used as source or target CCSIDs for EBCDIC or ASCII data. DB2 does not support the storing of data into all of these CCSIDs. That is, not all of the numbers listed in the first table below are supported as target CCSIDs in conversion. When you choose CCSIDs, you should choose an EBCDIC CCSID and an ASCII CCSID that are listed in the same row in the first table below.
To determine which combinations DB2 supports with SYSSTRINGS, issue the following SQL statement:
SELECT * FROM SYSIBM.SYSSTRINGS;
If you specify MIXED DATA=NO on installation panel DSNTIPF, specify an SBCS CCSID from the second table below in the EBCDIC CCSID field on DSNTIPF. You must specify a SBCS CCSID from the third table below in the ASCII CCSID field on DSNTIPF. Mixed character data and graphic data cannot be defined on a system when you specify MIXED DATA=NO.
If you specify MIXED DATA=YES on installation panel DSNTIPF, specify a mixed data CCSID from the second table below in the EBCDIC CCSID field on DSNTIPF. You must specify a mixed CCSID from the third table below in the ASCII CCSID field. The second and third tables below show the associated CCSIDs that DB2 assigns for SBCS and DBCS data when you specify a specific MCCSID.
Then specify a mixed CCSID from the third table in the ASCII CCSID field on DSNTIPF. By specifying a CCSID for mixed data (an MCCSID), you also receive system CCSIDs for SBCS and DBCS (graphic) data.
In the second and third tables, four CCSIDs are listed for Japanese to allow for all possible combinations of two single-byte code pages and two double-byte character sets. The difference between the single-byte code pages is in the code points for lowercase Latin letters and Katakana characters. In the code page for Japanese (Extended English, SCCSID 1027), lowercase letters have the same code points as other EBCDIC code pages.
In these tables, the terms are used as follows:
- SCCSID
- single-byte coded character set identifier
- MCCSID
- mixed coded character set identifier
- GCCSID
- graphic coded character set identifier
| Country or national language | EBCDIC | ASCII PC | ASCII AIX® | ASCII Windows |
|---|---|---|---|---|
| Australia (U.S. English) | 37/1140* | 437 | 819 | 1252/5348* |
| Austria (German) | 273/1141* | 850/858* | 819 | 1252/5348* |
| Belarus (Cyrillic) | 1025 | 1251/5347* | ||
| Belgium | 500/1148* | 850/858* | 819 | 1252/5348* |
| Bosnia and Herzegovina (Cyrillic) | 1025 | 1251/5347* | ||
| Bosnia and Herzegovina (Latin) | 870 | 852 | 912 | 1250/5346* |
| Brazil (U.S. English) | 37/1140* | 850/858* | 819 | 1252/5348* |
| Bulgaria (Cyrillic Multilingual) | 1025 | 1251/5347* | ||
| Canada (U.S. English) | 37/1140* | 850/858* | 819 | 1252/5348* |
| Croatia | 870 | 852 | 912 | 1250/5346* |
| Czech Republic | 870 | 852 | 912 | 1250/5346* |
| Denmark | 277/1142* | 850/858* | 819 | 1252/5348* |
| Finland (Swedish) | 278/1143* | 850/858* | 819 | 1252/5348* |
| France | 297/1147* | 850/858* | 819 | 1252/5348* |
| Germany | 273/1141* | 850/858* | 819 | 1252/5348* |
| Greece | 875 or 423 | 869 | 813 | 1253/5349* |
| Hungary | 870 | 852 | 912 | 1250/5346* |
| Iceland | 871/1149* | 850/858* | 819 | 1252/5348* |
| International Latin-1 | 500/1148* | |||
| Israel | 424 | 862 | 916 | 1255/5351* |
| Italy | 280/1144* | 850/858* | 819 | 1252/5348* |
| Latin America (Spanish) | 284/1145* | 850/858* | 819 | 1252/5348* |
| FYR Macedonia | 1025 | 1251/5347* | ||
| Netherlands (U.S. English) | 37/1140* | 850/858* | 819 | 1252/5348* |
| New Zealand (U.S. English) | 37/1140* | 437 | 819 | 1252/5348* |
| Norway | 277/1142* | 850/858* | 819 | 1252/5348* |
| Poland | 870 | 852 | 912 | 1250/5346* |
| Portugal (U.S. English) | 37/1140* | 850/858* | 819 | 1252/5348* |
| Russia (Cyrillic) | 1025 | 1251/5347* | ||
| Serbia and Montenegro (Cyrillic) | 1025 | 1251/5347* | ||
| Serbia and Montenegro (Latin) | 870 | 852 | 912 | 1250/5346* |
| Spain | 284/1145* | 850/858* | 819 | 1252/5348* |
| Sweden | 278/1143* | 850/858* | 819 | 1252/5348* |
| Switzerland | 500 /1148* | 850/858* | 819 | 1252/5348* |
| Thailand | 838 | |||
| Turkey (Latin 5) | 1026 | 857 | 920 | 1254/5350* |
| United Kingdom | 285/1146* | 850/858* | 819 | 1252/5348* |
| U.S.A. (U.S. English) | 37/1140* | 437 | 819 | 1252/5348* |
| Note: * This number represents the equivalent CCSIDs using the euro symbol. | ||||
| National language | MCCSID | SCCSID | GCCSID | User-defined characters |
|---|---|---|---|---|
| Japanese (Extended Katakana) | 930 | 290 | 300 | 4370 |
| Japanese (Katakana-Kanji) | 1390 | 8482 | 16684 | 6205 |
| Japanese (Extended Katakana) | 5026 | 290 | 4396 | 1880 |
| Japanese (Extended English) | 939 | 1027 | 300 | 4370 |
| Japanese (Latin-Kanji) | 1399 | 5123 | 16684 | 6205 |
| Japanese (Extended English) | 5035 | 1027 | 4396 | 1880 |
| Korean | 933 | 833 | 834 | 1880 |
| Korean | 1364 | 13121 | 4930 | 1880 |
| Simplified Chinese | 935 | 836 | 837 | 1880 |
| Simplified Chinese | 1388 | 13124 | 4933 | 1880 |
| Traditional Chinese | 937 | 28709 | 835 | 6204 |
| National language | MCCSID | SCCSID | GCCSID | User-defined characters |
|---|---|---|---|---|
| Japanese | 932 | 897 | 301 | 1880 |
| Japanese (Extended) | 942 | 1041* | 301 | 1880 |
| Japanese (Open environment) | 943 | 1041* | 941 | 1880 |
| Japanese (HP) | 5039 | 1041* | 1351 | 940 |
| Korean | 949 | 1088 | 951 | 1880 |
| Korean (EUC) | 970 | 367 | 971 | 1880 |
| Korean | 1363 | 1126 | 1362 | 1880 |
| Simplified Chinese | 1381 | 1115 | 1380 | 1880 |
| Simplified Chinese (EUC) | 1383 | 367 | 1382 | |
| Simplified Chinese | 1386 | 5210 | 1385 | 1880 |
| Traditional Chinese | 938 | 904 | 927 | 6204 |
| Traditional Chinese | 948 | 1043 | 927 | 6204 |
| Traditional Chinese (IBM® Big-5) | 950 | 1114 | 947 | |
| Note: * The SCCSID 1041 is a superset of SCCSID 897. | ||||