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)
