Elias Martenson wrote: > > Peter Willadt wrote: > > Hello, > > On Donnerstag, 20. M�rz 2003 20:03, Andris Spruds wrote: > > > >>Yes, it's not very well documented, but SAPDB internaly > converts all table > >>names to uppercase. So, instead of 'person', use 'PERSON' > > > > This does not need to be documented, as it is standard sql > behaviour. > > When you want a table name to be in lowercase, you have to > use double quotes > > during creation and ever after when you want to refer to it. > > For some reason Microsoft consider themselves above this > standard. They > feel that square brackets are a better way to go. Are they > really ANSI > SQL compliant?
ANSI (SQL99 / SQL3) says: letters in a non-delimited-identifier are treated and returned when selecting the dictionary as if they were given as upper-case letters. delimited identifier are surrounded by double quotes, nothing else, no single quote, no brackets. > > And does Sybase the same thing? They also support the user of double > quotes for quoting strings as an alternative to single quotes? > Now we are talking of string-literals, not to be mixed with delimited (quoted) identifiers: according to SQL99, string_literals are surrounded by single_quote, nothing else. > How about a comaptibility mode in SapDB to support MS (and > Sybase?) syntax? > No, please not. Those compatibility-modes we have are hard enough to manage, we will not increase the number of compatibility-modes. > Regards > > Elias Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
