Also, please take a look at this thread ...
http://groups.google.com/groups?q=change+database+charset+oracle&hl=en&lr=&s
elm=adtb4s%24enh%241%40coco.singnet.com.sg&rnum=2
Anurag
"zeb" <thierry.constant1_at_free.fr> wrote in message
news:3d10e740$0$476$626a54ce_at_news.free.fr...
> Hi,
>
> I want to change the charset from my database from WE8ISO8859P1 to
> a database UTF8 , I loose some french characters ( like é , ç ...)
>
> - to export the database
> NLS_LANG= american_america.WE8ISO8859P1 right ????
>
> - drop the 8859 database and create a new database UTF8
>
> - to import the file into the database
> NLS_LANG=american_america.UTF8 right ???
>
> to see my data:
> NLS_LANG=american_america.UTF8 right ???
>
>
> doing that, I loose some french characters ( like é , ç ...)
>
> what is the right way to do that ??
>
> thanks ...
>
> ( config: 8.1.6 , HP-UX 11.0 )
>
>
Received on Wed Jun 19 2002 - 18:05:23 CDT
