Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Character Set issues
Yes - I set
export NLS_LANG=american_america.WE8ISO8859P1 export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
in my export/import scripts and everything is now fine.
thanks
Tom
"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message
news:ubs2owu6y.fsf_at_standardandpoors.com...
> On Fri, 10 Jan 2003, tomNOSPAM_at_teameazyriders.com wrote:
> > Hi,
> > can anyone please spot where i'm going wrong?
>
> From documentation on export.
>
> The Export utility always exports user data, including
> Unicode data, in the character sets of the Export
> server. The character sets are specified at database
> creation.
>
> The Import utility automatically converts the data to the
> character sets of the Import server.
>
> Some 8-bit characters can be lost (that is, converted to
> 7-bit equivalents) when you import an 8-bit character set
> export file. This occurs if the client system has a
> native 7-bit character set or if the NLS_LANG operating
> system environment variable is set to a 7-bit character
> set. Most often, you notice that accented characters lose
> their accent mark.
>
> So, check you NLS_LANG settings on the OS you are export to.
> --
> Galen Boyer
Received on Sat Jan 11 2003 - 10:55:23 CST