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: Export/import from different character sets

Re: Export/import from different character sets

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 24 Aug 2001 23:11:00 +0200
Message-ID: <todm6fe9b2rhee@news.demon.nl>

"Bilal EL JOUZOU" <bjouzou_at_fluxus.net> wrote in message news:9m60hf$1oua$1_at_news6.isdnet.net...
> Hi
> I have a database with US7ASCII character set the DB contains data with
> french characters like é à and so. I want to move tha data from this
> instance to another on with UTF8 character set. any sugestion for that.
> Thanks
>
> Bilal
>
>

Sigh, no version, no platform.
If you request help please provide information so no guesswork is necessary. You need to set NLS_LANG to American_America.US7ASCII, provided your database is in UTF8, imp will perform the conversion for you.

Hth,
Sybrand Bakker, Senior Oracle DBA Received on Fri Aug 24 2001 - 16:11:00 CDT

Original text of this message

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