Home » RDBMS Server » Server Administration » Migration
Migration [message #201270] Fri, 03 November 2006 06:18
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,

Previous Topic: 10G install doesnt include Apache installation ?
Next Topic: convertin html format stroed in CLOB to .DOC file
Goto Forum:

Current Time: Mon Oct 24 09:54:23 CDT 2016

Total time taken to generate the page: 0.12792 seconds