Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: pb changing charset

Re: pb changing charset

From: Anurag <avdbi_at_hotmail.com>
Date: Wed, 19 Jun 2002 18:55:06 -0400
Message-ID: <uh22upeljp4173@corp.supernews.com>


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 ???

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

NLS_LANG=American_America.WE8ISO8859P1

>
> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US