[Dbix-class] Case sensitivity in column names using Oracle

[Stephan Szabo]

On Tue, 14 Feb 2006, Matt S Trout wrote:

> On Tue, Feb 14, 2006 at 11:31:12AM +0100, Karl.Moens at marsh.com wrote:
> > Matt wrote:
> >
> > > does anybody know if
> > > there are any databases that'll let you have foo, Foo and FOO all as
> > column
> > > names on the same table?
> >
> > At least MySQL does not allow you to have colums with names which only
> > differ because of their case.
>
> Yeah, I already knew that. Trouble is what we need to know is if that's
> the general case - one exception would cause breakage for people using said
> exceptional DB and I'd prefer to avoid that if possible :)


The spec explicitly seems to allow "FOO" and "foo" and "Foo" (with the
quotes) as distinct identifiers. Paraphrased: two delimited identifiers
are equivalent if their inner parts considered as a character string
literal compare equally with an implementation-defined collation that is
sensitive to case.  I know postgres should do this part properly (although
it gets the case-folding for non-delimited identifiers wrong).