RE: How to transfer data in different NLS_CHARACTER
Martin - Since I don't see any reply to your question (U.S. holiday), I would start with the Oracle National Language Support Guide. From past postings on this list, I believe that you can export the data from your American (8-bit characters) language database and import it into your Chinese (16-bit characters) language database. Here is a link that offers some information. http://www.desy.de/asg/oracle/impexp/impexp.html I also see notes that suggest you can do this with a SQL*Net link. I believe in Oracle9i, you will be encouraged to migrate to one of the Unicode character sets. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 27, 2002 9:24 PM To: Multiple recipients of list ORACLE-L Dear all , How to transfer data from 2 oracle server with different NLS_LANG ? NLS_LANG=Traditional Chinese_Taiwan.ZHT16BIG5 NLS_LANG=American_America.WE8ISO8859P1 Thanks in advance. Martin Chen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ??? INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to transfer data in different NLS_CHARACTER
??? wrote: Dear all , How to transfer data from 2 oracle server with different NLS_LANG ? NLS_LANG=Traditional Chinese_Taiwan.ZHT16BIG5 NLS_LANG=American_America.WE8ISO8859P1 Thanks in advance. Martin Chen Martin, Although I have of late had some interest in chinese character sets, I am still a novice at the way Oracle implements and handles them, but basically one character set has to be a superset of the other if you want things to work. If ZHT16BIG5 is the two-byte code it looks to be AND if codes 0 to 255 match the corresponding code in WE8ISO8859P1, then you can probably export from the 'western' database and import into the 'eastern' one (not the other way round). Personally I would worry about the 128 to 255 range, which contains all the various accentuated or plainly weird characters which spice up German, French, Italian, Danish, Norwegian, Swedish, Finnish, Icelandic perhaps, Spanish, and slavic languages (I hope to have forgotten nobody). If you cannot find them in ZHT, even if you do not use them, I fear that West will stay west, that east will stay east, and that the twain shall not meet, at least as far as imp and exp are concerned. I think that in that case the best you have to do is to rely on plain flat files, which you can doctor at will if needed. Then tell SQL*Loader something plausible about the character set, and it should work. -- HTH, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
