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

Matt S Trout dbix-class at trout.me.uk
Tue Feb 14 13:33:51 CET 2006


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 :)

(sometimes I really hate databases ...)

-- 
     Matt S Trout       Offering custom development, consultancy and support
  Technical Director    contracts for Catalyst, DBIx::Class and BAST. Contact
Shadowcat Systems Ltd.  mst (at) shadowcatsystems.co.uk for more information

 + Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +



More information about the Dbix-class mailing list