On Tue, 14 Feb 2006, Matt S Trout wrote: > On Tue, Feb 14, 2006 at 11:31:12AM +0100, [EMAIL PROTECTED] 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). _______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
