Re: CharacterSet Followup

Should be something with your O/S. Oracle is case sensitive all the way down, in each characterset, including US7ASCII, and has always been case sensitive.
So I really can't imagine getting uppercase only is caused by Oracle. That's simply impossible.

Hth,

Sybrand Bakker, Oracle DBA

"Rob Zwartjes" <rzwartje_at_rob.home.nl> wrote in message news:slrn8lsnhn.6hi.rzwartje_at_rob.home.nl...
> Hello there,
> as the subject already said this is a followup from my previous question.
> Probably I should have looked in the oracle pdf a little bit more but OK
 the
> next time I will read more and ask later. :)
> What I found does make sence but doesn't work.
> Here it is:
> I started svrmgrl and did the following
> connect internal;
> shutdown immediate;
> startup mount;
> alter system enable restricted session;
> alter system set job_queue_processes=0;
> alter database open;
> alter database character set WE8ISO8859P1;
> alter database national character set WE8ISO8859P1;
> shutdown immediate;
> startup;
> Then I logged in as normal user and made a new table with upper and lower
> case field names. It doesn't work. Still only upper case letters.
> The above statements I got from the a67789.pdf from Oracle8i and I am
 running
> oracle 8.0.5.1. Is this why I can't make it work or am I forgetting
> something??
>
> Thanks in advance,
> Rob
Received on Sun Jul 02 2000 - 00:00:00 CDT