Re: Case sensitivity in Mysql

2002-03-14 Thread BD
At 11:17 AM 3/14/2002, you wrote: >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_NUMBE

Re: Case sensitivity in Mysql

2002-03-14 Thread Christopher Thompson
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 ref

Re: Case sensitivity in Mysql

2002-03-14 Thread BD
At 02:05 AM 3/14/2002, you wrote: >Hi, >I run mysql on windows as well as linux. >table creation and access right are given by java program. > >Problem im facing is., >i create a table with name TEMP >in windows in creates table with name "temp" and linux "TEMP" >while giving rights thru GRANTst