Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export / Import and CharacterSets
Thanks, Piotr, but this didn't work. The documentation says, the charset
parameter is for release 6 export files only, and it's use is not
recommended in Ora 7. (And I tried it, but it did not make any
difference.)
Yes, it is possible to store and retrieve German characters in a US7ASCII database. I'm a bit surprised too.
Piotr Kolodziej wrote:
>
> Rolf Hauck wrote in message <360A316D.D51F99F9_at_datenrevision.de>...
> >I'm trying to transport character data from our develepment database to
> >production database, and I'm losing all my German characters. The
> >development system is set up with NLS_LANG=AMERICAN_AMERICA.US7ASCII
> >(Oracle 7.3.2.3). The production system uses
> >AMERICAN_AMERICA.WE8ISO8859P1 (Oracle 7.3.4).
> >I can't make exp/imp behave like it's documented:
>
> Generally, you may specify charset parameter while executing imp.
> This charset says in which charset your export was performed.
> $ imp user/passwd file=foo log=foo charset=<charset> <other_params>
>
> So according to your description try using:
> imp user/passwd file=foo log=foo charset=us7ascii <other_params>
>
> BTW, is it really possible keeping German characters in us7ascii ???
>
> HTH,
> Piotr Kolodziej
> pkol_at_otago.gda.pl
Received on Thu Sep 24 1998 - 07:47:56 CDT