| Migration [message #201270] |
Fri, 03 November 2006 06:18 |
carthyc
Messages: 20
Registered: April 2005
Location: chennai
|
Junior Member |
|
|
Dear All,
I am running an application in Greece using "ISO 8859-7" in client PC (since Greek is supported only using P7) and with "WE8ISO8859P1" in the server with 8i installation!
Now I would like to migrate our database into Oracle9i and to have Unicode support. Hence I decided to use NLS_CHARACTER as "AL32UTF8" and NLS_NCHAR_CHARACTER as "AL16UTF8".
So far I am not sure about the data stored in database but we get correct output in client's PC.
I took the dump from server using "WE8ISO8859P1" and imported it into the new database created with NLS_CHARACTER as "AL32UTF8" and NLS_NCHAR_CHARACTER as "AL16UTF8". I used the NLS_CHARACTERSET = "WE8ISO8859P1" during both export and import. But I get junk letters or some other letters while viewing the data from client PC.
I would like to get guidance from you which characterset should be used during both export and import of data.
Thank you all in advance,
McArthyc.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
