Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export/import from different character sets
"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