Re: SQL standard on case sensitivity

The standard is case-insensitive for undelimited identifiers.  The 
problem with DBD::File is that some operating systems are case sensitive 
when it comes to file names so if there is a one-to-one table/file 
correspondance, there can be problems.

-- 
Jeff

H.Merijn Brand wrote:
> 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";
>
> 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)
>
>