Home » SQL & PL/SQL » Client Tools » Import Dump with character set WE8MSWIN1252 into database with character set WE8ISO8859P1 (Oracle11g, Windows)
Import Dump with character set WE8MSWIN1252 into database with character set WE8ISO8859P1 [message #610576] Fri, 21 March 2014 08:40 Go to next message
AndiD
Messages: 2
Registered: March 2014
Junior Member
Hello,
oracle-11g on Windows
it seems that both character sets: WE8MSWIN1252 and WE8ISO8859P1 use Byte for some NLS data.
However, when I import a dump (I only have the dump and no access to the original database) into my database I get the following message:
import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
export client uses WE8MSWIN1252 character set (possible charset conversion)


Now, changing the NSL on the server in the Registry won't help because then I get the message:
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)

So now, import server is the culprit. Can I somehow influence import server too and change it to WE8MSWIN1252?

Is there an easy solution?
Obviously the dump was done with character set WE8MSWIN1252 and no matter what I do, imp will read it into the database using WE8ISO8859P1.
Then the special characters of the German language (ä ä, ö ö,ß ß etc) will not be recognized anymore although all special chars inserted afterwards will work.

Would sb. have suggestions?
Appreciation guaranteed!
Andi
Re: Import Dump with character set WE8MSWIN1252 into database with character set WE8ISO8859P1 [message #610601 is a reply to message #610576] Fri, 21 March 2014 12:29 Go to previous messageGo to next message
Michel Cadot
Messages: 60058
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The emphasized messages are just informational, there are no lost of data, as far as I know, all characters WIN1252 are in ISO8859P1 and vice versa but not always with the same code point. For instance, € is code 128 in WIN1252 and 191 in ISO8859P1 but both character sets have the same code point for ä (228).

If you have lost of data this means than at one step of the process the character set you give to Oracle was incorrect.

Re: Import Dump with character set WE8MSWIN1252 into database with character set WE8ISO8859P1 [message #611132 is a reply to message #610601] Fri, 28 March 2014 04:07 Go to previous messageGo to next message
AndiD
Messages: 2
Registered: March 2014
Junior Member
Hi,
I figured that the characters are contained in both character sets (as both have Byte-Size).
But the fact that for some special characters - like ß - nothing is found and instead a ? is displayed shows that there is a problem during import. Yet when I use the database and do some input this character will work.

Is there a way to map the characters correctly during import?

Thank you
Andi
Re: Import Dump with character set WE8MSWIN1252 into database with character set WE8ISO8859P1 [message #611168 is a reply to message #611132] Fri, 28 March 2014 11:36 Go to previous message
Michel Cadot
Messages: 60058
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

ß has the same code point in both character sets.
As I previously said,

Quote:
If you have lost of data this means than at one step of the process the character set you give to Oracle was incorrect.


The problem is NOT in Oracle database it is in your process to insert the data in the first database, export the data, import the data in the other database or retrieve the data in this later one.

Previous Topic: Where to download Toad and How to install in Personal Pc
Next Topic: Toad Data modeller 4.3
Goto Forum:
  


Current Time: Thu Dec 25 21:52:14 CST 2014

Total time taken to generate the page: 0.24592 seconds