Home » RDBMS Server » Server Utilities » changing character sets
changing character sets [message #367961] Mon, 03 May 1999 09:50 Go to next message
Anne-Marie Ternes
Messages: 2
Registered: May 1999
Junior Member
Hi!

I need to export data from database 1, character set US7ASCII, to database 2, character set WE8ISO8859P1.

I have database 1:
NLS_TERRITORY = AMERICA
NLS_LANGUAGE = AMERICAN
character set: US7ASCII

Database 2 has character set WE8ISO8859P1.

I found the Oracle documents on the topic rather obscure, and I found no precise example.

So, my question is:
1) during export, which territory, language and character set must I specify on my client machine?
2) during import, same question.
3) are these client parameters also used if exp/imp is done via an Exceed xterm window, or a telnet?
4) do, for example, territory AMERICA and charset West-European contradict?

I tried the following combinations:
1) exp: host us7ascii, client us7ascii
imp: host we8iso..., client us7ascii
2) exp: host us7ascii, client us7ascii
imp: host we8iso..., client we8iso...
3) exp: host us7ascii, client we8iso...
imp: host we8iso, client we8iso...
4) exp: host us7ascii, client we8iso...
imp: host we8iso..., client us7ascii

Language and Territory were each time american.
I never succeeded in seeing my accentuated characters correctly.

I'd be glad for any help,

thank you very much

Anne-Marie Ternes
Re: changing character sets [message #368177 is a reply to message #367961] Fri, 22 September 2000 10:11 Go to previous messageGo to next message
Yvon Dionne
Messages: 1
Registered: September 2000
Junior Member
Hello Anne-Marie,

We have to convert a database from US7ASCII to WE8ISO8859P1. So I found your question but I did not found my answer. Have you finally did it if so how did you did it?

Thank you for your time

Yvon Dionne 514-858-8500 8073
Re: changing character sets [message #368180 is a reply to message #368177] Sun, 24 September 2000 15:42 Go to previous message
Anne-Marie Ternes
Messages: 2
Registered: May 1999
Junior Member
Hi,

You are right, I did it with some success. You have to be careful, however.
I wrote a help document on the topic, which I don't have at hand now, unfortunately.
But I'll get it probably tommorrow evening, so I can send it to you.

See you,

Anne-Marie
Previous Topic: SQL*Loader help on populating fields with data lookup
Next Topic: Help:Net8 Assistant can't run???
Goto Forum:
  


Current Time: Sat May 21 05:09:44 CDT 2022