Re: US7ASCII and WE8ISO8859P1 blues

"Gijsie" <gijs.de.wolff_at_beheervisie.nl> wrote in message news:<407563ba$0$559$e4fe514c_at_news.xs4all.nl>...
> Hi,
>
> I have the following problem. I have a 8.1.7 Oracle server with a
> WE8ISO8859P1 characterset. The server behaves however as if she uses
> US7ASCII.
>
> Whatever can cause this behaviour. The following SQL and replies will
> demonstrate my problem:
>
> Q: select 'h' from dual;
> A: h
>
> Q: select chr(104) from dual;
> A: h
>
> Q: select 'è' from dual;
> A: h
>
> Q: select chr(232) from dual;
> A: h
>
> Since US7ASCII is a 128-charset a US7ASCII server answers chr(232) as
> chr(232-128).
> My WE8ISO8859P1-server however does exactly the same.
>
> Can anybody please explain this strange behaviour.
>
> Thanks,
> Gijs de Wolff

You need to set the proper NLS variables both for your server environment and the environment sqlplus is running in. The default is US7ASCII. This is especially important for export/import, as friendly and helpful Oracle will automatically translate characters. http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76966/ch2.htm#91066 and don't forget ORA_NLS33
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76966/ch1.htm#41083 .

jg

--
@home.com is bogus.
http://www.rinkworks.com/dialect/