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
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
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
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 GRANTstatement , it fails in windows cause it
exp
Hi,
I have a situation as follows:
There is a table that stores the user name.
One user name is 'David' and another is 'david'
I want to select only the user with the name
'david'(all small and not 'David')
MySQL is case insensitive in selecting records...
how to make it case-sensitive in selec
