On Thursday 14 March 2002 9:32 am, BD wrote: > > Why or why couldn't MySQL have used case insensitive names in the first > place? Store everything in lower case internally, but allow the user to use > "Invoice_Number" or "invoice_number" or "INVOICE_NUMBER" in the SQL > statement and it should refer to the same column. Same with table names. I > don't see why you would want to have 3 different columns in the same table > with names "Invoice_Number", "invoice_number" and "INVOICE_NUMBER". Maybe > it's just me, but it doesn't make a lot of sense to have case insensitive > names. It just leads to typos and the code doesn't run. :-(
In SQL92, identifiers can only be uppercase letters and numerals. Therefore, if you are using lowercase, you are NOT writing valid SQL92. Most databases will allow this, of course. SQL99 adds support for lowercase characters but MySQL doesn't claim to implement SQL99 yet. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
