Re: JDBC bug?

From: "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC bug?
Date: 2001-11-26 21:58:31
Message-ID: 20011126155831.C5801@rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Mon, Nov 26, 2001 at 01:02:53PM -0800, Nate Gelbard wrote:
>
> > of a complaint on how SQL is case insensitive and if you have created
> > your objects with quoted mixed case identifiers you need to accessthem
> > via quoted mixed case identifiers. I haven't seen any evidence that
>
> I am mistaken. This is actually a bug in the applications that are
> building SQL statements without quotes around tablenames of mixedcase.

Bad apps are everywhere. I've met quite a few that make the Oracle assumption
about casefolding: MixedCase == MIXEDCASE i.e. Oracle upcases everything.

The other place you'll hit this is NTFS (i.e. NT file system): names are
casepresevering but _not_ case sensitive, so MixEdCase == MIXEDCASE ==
mixecase all conflict, but will be stored (and returned) however the
app. (or user) spelled it the first time. Another example of being overly
helpful.

Ross

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Rene Pijlman 2001-11-26 22:54:04 Re: JDBC bug?
Previous Message Ross J. Reedstrom 2001-11-26 21:54:47 Re: JDBC bug?