Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export/import from different character sets
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> a écrit dans le message news:
todm6fe9b2rhee_at_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
>
>
Hi,
As this have nothing to do with the OS I didn't mention it as for the oracle
version it is 8.1.5 (source) and 8.1.7 (target) and the solution of
exporting/importing in US7ASCII (for the NLS_LANG) just did not work (that
why I posted my message) it looses all the special french characteres
any other solution
Thanks in advance
Bilal
Received on Mon Aug 27 2001 - 04:20:08 CDT