Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: US7ASCII and WE8ISO8859P1 blues

Re: US7ASCII and WE8ISO8859P1 blues

From: Joel Garry <joel-garry_at_home.com>
Date: 8 Apr 2004 13:45:18 -0700
Message-ID: <91884734.0404081245.2707f145@posting.google.com>


"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/
Received on Thu Apr 08 2004 - 15:45:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US