Re: All output in UPPER case and with s p a c e s in SQL*Plus

Thomas Reinartz <Thomas.Reinartz_at_debis.com> wrote in message news:<3c4d3a2e$1_at_netnews.web.de>...
> Hi,
>
>
> I'm doing "select * from table_name;" within SQL*Plus (Client 8.0.5, Server 8.1.
> 7, compatible mode 8.1.0) and I receive strange output. It looks something like
>
>
> C O L U M N N A M E
> ----------------------
> R O W 1
> R O W 2
> A N D S O O N
>
>
> All output is in upper case and has spaces between the letters. Using TOAD I see
> no output at all.
>
>
> Somebody with an idea?
>
>
> Thanks in advance
>
>
> Thomas

Hi Thomas,
we have exactly the same problem. What NLS Characterset do you use on the server? I just upgraded an ORACLE Server from 8.0.5 to 8.1.7 and also changed the (Server-)NLS character set from WE8ISO8859P1 to WE8ISO8859P15 because the last one supports the EURO sign. Since I did this, my 8.0.5 clients are giving the UNICODE styled VARCHAR2 columns. The 8.1.7 clients are working fine.
So I tried to change the client side NLS character to WE8ISO8859P15, but the 8.0.5 client do not know this character set. So I think that's the problem... SQL*Net do not know how to convert the charactersets. But I have no solution yet.

Anyone else???

Regards,
Christoph Received on Mon Feb 04 2002 - 11:16:44 CST