|
Home
Products
Downloads
Registration
Articles
Scripts
Links
About Us
Free Newsletter
|
NLS CONSIDERATIONS WHEN DOING EXPORT/IMPORT
If you are encounter character set conversion problems during exported
or imported a database or table(s) check the following information to
confirm whether the export/import procedure was performed correctly:
1.Establish NLS_LANG environment variable for Import session.
2.Import reads the Export character set ID from the dump file and
compares it with the session's character set as defined in NLS_LANG.
No conversion occurs if the Export character set and the Import
session character set are the same. If they are not the same,
conversion is performed from the Export character set to the Import
session character set prior to the data being inserted into the
database. However, import can only perform this conversion for
single-byte character sets. For imports into multibyte character
set databases (i.e. UTF8) the character set part of NLS_LANG should
be set identical to that of the export session.
3.The Import session character set should be a superset of the Export
character set otherwise special characters will not be correctly
converted.
4.After the data has been converted to the Import session character
set, it is then converted to the database character set if they
differ. The database character set should be a superset of the
Import's session character set otherwise special characters will not
be correctly converted.
Following is the NLS supported character sets:
Id Character set Description
--------------------------------------------------------
001 US7ASCII ASCII 7-bit American
002 WE8DEC West European
003 WE8HPHP LaserJet West European
004 US8PC437 Code Page 437 American
005 WE8EBCDIC37 Code Page 37 West European
006 WE8EBCDIC500 Code Page 500 West European
010 WE8PC850 Code Page 850 West European
011 D7DEC VT100 7-bit German
012 F7DEC VT100 7-bit French
013 S7DEC VT100 7-bit Swedish
014 E7DEC VT100 7-bit Spanish
015 SF7ASCII ASCII 7-bit Finnish
016 NDK7DEC VT100 7-bit Norwegian/Danish (Norwegian sort)
017 I7DEC VT100 7-bit Italian
018 NL7DEC VT100 7-bit Dutch
019 CH7DEC VT100 7-bit Swiss (German & French)
020 DKN7DEC Danish sort DEC VT100 7-bit Norwegian/Danish
021 SF7DEC VT100 7-bit Finnish
022 TR7DEC VT100 7-bit Turkish
031 WE8ISO8859P1 ISO 8859-1 West European
032 EE8ISO8859P2 ISO 8859-2 East European
033 SE8ISO8859P3 ISO 8859-3 South European
034 NEE8ISO8859P4 ISO 8859-4 North and North-East European
035 CL8ISO8859P5 ISO 8859-5 Latin/Cyrillic
036 AR8ISO8859P6 ISO 8859-6 Latin / Arabic
037 EL8ISO8859P7 ISO 8859-7 Latin / Greek
038 IW8ISO8859P8 ISO 8859-8 Latin / Hebrew
039 WE8ISO8859P9 ISO 8859-9 West European & Turkish
041 TH8TISASCII Thai Industrial Standard 620-2533 (ASCII)
042 TH8TISEBCDIC Thai Industrial Standard 620-2533 (EBCDIC)
081 EL8DEC Latin / Greek
082 TR8DEC Turkish
090 WE8EBCDIC37C Code Page 37 Oracle/c
091 WE8EBCDIC500C Code Page 500 Oracle/c
100 EEC8EUROPC EURO-PC West European/Greek
101 EEC8EECEUROUNIX EURO-UNIX West European/Greek
102 WE8EEC8859P1 EURO-UNIX copy of ISO 8859-1
103 EL8EEC8859P7 EURO-UNIX copy of ISO 8859-7
110 EEC8EUROASCI Targon 35 ASCI West European/Greek
111 EEC8ISO8859P1 Targon 35 copy of ISO 8859-1
112 EEC8ISO8859P7 Targon 35 copy of ISO 8859-7
113 EEC8EUROPA3 EUROPA3 West European/Greek
154 HU8ISO8859P2 Hungarian sort ISO 8859-2
150 EE8PC852 Code Page 852 East European
152 RU8PC866 Code Page 866 Latin/Cyrillic
153 RU8BESTA BESTA Latin/Cyrillic
155 RU8PC855 Code Page 855 Latin/Cyrillic
156 TR8PC857 Code Page 857 Turkish
157 CL8MSWINDOW31 Windows 3.1 Latin/Cyrillic
158 CL8MACCYRILLIC Mac Latin/Cyrillic
160 WE8PC860 Code Page 860 West European
180 D8EBCDIC273 Code Page 273/1 Austrian/German
181 I8EBCDIC280 Code Page 280/1 Italian
182 DK8EBCDIC277 Code Page 277/1 Danish
183 S8EBCDIC278 Code Page 278/1 Swedish
190 N8PC865 Code Page 865 Norwegian
201 F7SIEMENS9780X 97801/97808 7-bit French
202 E7SIEMENS9780X 97801/97808 7-bit Spanish
203 S7SIEMENS9780X 97801/97808 7-bit Swedish
204 DK7SIEMENS9780X 97801/97808 7-bit Danish
205 N7SIEMENS9780X 97801/97808 7-bit Norwegian
206 I7SIEMENS9780X 97801/97808 7-bit Italian
207 D7SIEMENS9780X 97801/97808 7-bit German
221 US8BS200 9750-62 EBCDIC American
222 D8BS2000 9750-62 EBCDIC German
223 F8BS2000 9750-62 EBCDIC French
224 E8BS200 9750-62 EBCDIC Spanish
225 DK8BS2000 9750-62 EBCDIC Danish
231 WE8BS2000 EBCDIC.DF.04 West European
239 WE8BS2000L5 Siemens EBCDI+.DF.04.L5 WE & Turkish
241 WE8DG DG West European
251 WE8NCR4970 NCR 4970 West European
261 WE8ROMAN8 HP Roman8 West European
301 N8ISO8859P1 Norwegian sort ISO 8859-1
302 N8DEC Norwegian sort West European
303 N8HP Norwegian sort HP LaserJet
304 N8EBCDIC37 Norwegian sort Code Page 37
305 N8EBCDIC500 Norwegian sort Code Page 500
306 N8PC850 Norwegian sort Code Page 850
307 N8ROMAN8 Norwegian sort HP Roman8
311 DK8ISO8859P1 Danish sort ISO 8859-1
312 DK8DEC Danish sort West European
313 DK8HP Danish sort HP LaserJet
314 DK8EBCDIC37 Danish sort Code Page 37
315 DK8EBCDIC500 Danish sort Code Page 500
316 DK8PC850 Danish sort Code Page 850
317 DK8ROMAN8 Danish sort HP Roman8
321 S8ISO8859P1 Swedish sort ISO 8859-1
322 S8DEC Swedish sort West European
323 S8HP Swedish sort HP LaserJet
324 S8EBCDIC37 Swedish sort Code Page 37
325 S8EBCDIC500 Swedish sort Code Page 500
326 S8PC850 Swedish sort Code Page 850
327 S8ROMAN8 Swedish sort HP Roman8
331 SF8ISO8859P1 Finnish sort ISO 8859-1
332 SF8DEC Finnish sort West European
333 SF8HP Finnish sort HP LaserJet
334 SF8EBCDIC37 Finnish sort Code Page 37
335 SF8EBCDIC500 Finnish sort Code Page 500
336 SF8PC850 Finnish sort Code Page 850
337 SF8ROMAN8 Finnish sort HP Roman8
341 IS8ISO8859P1 Icelandic sort ISO 8859-1
351 WE8MACROMAN8 Mac Extended ROMAN8 West European
360 SK8ISO8859P2 Slovak sort ISO 8859-2
361 SK8PC852 Slovak sort Code Page 852
363 HU8PC852 Hungarian sort Code Page 852
364 CS8ISO8859P2 Czech sort ISO 8859-2
365 CS8PC852 Czech sort Code Page 852
366 PL8ISO8859P2 Polish sort ISO 8859-2
367 PL8PC852 Polish sort Code Page 852
368 HU8CWI2 Hungarian CWI-2
370 TR8ISO8859P9 Turkish version ISO 8859-9
380 EL8PC437S Greek modified Code Page 437
381 EL8EBCDIC875 Code Page 875 Greek
390 CDN8PC863 Code Page 863 Canadian French
401 HU8ABMOD Hungarian AB Mod
401 HU8ABMOD Hungarian AB Mod
590 LA8TELETEX Teletex Latin
829 JA16VMS Japanese VMS Kanji
830 JA16EUC Japanese Extended UNIX Code
832 JA16SJIS Japanese Shift-JIS
833 JA16DBCS Japanese IBM
839 JA16THOSHIBAEUC Toshiba version of JEUC
843 JA16HP Japanese HP
840 KO16KSC5601 Korean KSC5601
842 KO16DBCS Korean IBM
850 ZHS16CGB231280 Chinese GB2312-80
860 ZHT32CNS1164386 Taiwan Traditional Chinese
865 ZHT16BIG5 Big5 Traditional Chinese
|
