| changing character sets [message #367961] |
Mon, 03 May 1999 09:50  |
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  |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
