Re: SQL standard on case sensitivity

H.Merijn Brand wrote on 05/09/09 10:10:
> Can someone show me the case specifications for SQL?
> 
> I think that unless quoted table names are case insensitive, so
> 
>   SELECT * FROM FOO;
> 
> equals
> 
>   select * from foo;
> 
> but does not equal
> 
>   SELECT * from "Foo";

What you describe matches DB2 and Oracle behavior and, based on what Jonathan 
says in his email, the SQL standard.

> 
> IMHO, when selecting from files, unquoted table names should match
> case-insensitive, so a file named "Foo" should match all three, but
> file named "foo" should match the first two statements.
> 
> If I am right, I got the unquoted working in my current DBD::File,
> and I'm working on the second part (it currently matches too often)
>