Re: Export-Import across character sets

Hi,
Yes Oracle can convert one character set to another using exp/imp via convertional path.
You need to create exp file from previous database from computer with previous character set.
For example: from the a server with WE8ISO8859P1 in database and WE8ISO8859P1 in sql_net.
After you need copy exp file to a server or computer with US7ASCII in sql_net and import into database with
which was created with US7ASCII set.
How correct result will be you can check in advance using:  SELECT CONVERT( yourfield , 'US7ASCII', 'WE8ISO8859P1') "Conversion" FROM yourtable;
Using this method I converted French from WE8PC850 into WE8ISO8859P1.

Yours, Iurie.
Tvguide,CA, Oracle DBA.

Kenneth C Stahl wrote in message <384FCC02.8E51C83D_at_Unforgettable.com>...
>For some reason that totally escapes me, a data base that I work with was
>created with the WE8ISO8859P1 character set instead of US7ASCII. Does
>anyone know if there would be adverse effects if an export were taken from
>that database and then imported into a database with the US7ASCII character
>set? We are no where near Iceland so nothing has been inserted into the
>database which would use Icelandic characters.
Received on Thu Dec 09 1999 - 10:31:36 CST