Re: CharacterSet Followup

Try quoting field names?

Create table my_table ("FiELd1" number);

Would be able to confirm for you were I able to access Oracle now.

Sybrand Bakker wrote:

> 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 Mon Jul 03 2000 - 00:00:00 CDT