Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: pb changing charset
I've seen a number of threads in this group relating to db charset
conversion which you might want to refer to also.
NLS_LANG specifies the client side charset. Thus if you exported using a setting WE8ISO8859P1, I would expect the import to also specify the same (WE...). I've never done this myself ... so I might be wrong.
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 - 17:55:06 CDT