On May 9, 2009, at 4:10 PM, 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";
I don't know about the standard - but Sybase (and MS-SQL probably) is
case-sensitive by default, though that can be changed with the "sort-
order" configuration of the server.
The case-sensitivity (or not, if a case-insensitive sort order is
used) is valid both for table names/object names, and for strings.
Michael
--
Michael Peppler - Peppler Consulting
SaRL
mpepp...@peppler.org - http://www.peppler.org
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com
Sybase on Linux FAQ - http://www.peppler.org/FAQ/linux.html
