it depends of the collation of table, for example: if your table has
collation: utf8_english_ci, ci means case insensitive.
El jue, 02-06-2005 a las 09:43 -0400, Jerry Swanson escribió:
> Column type is username varchar(100).
>
> When I do select from database:
> "select * from user where
Jerry Swanson wrote:
Column type is username varchar(100).
When I do select from database:
"select * from user where username='John'"; //returns one row
"select * from user where username='john'"; //returns one row
The records in the database has username 'John'.
Why it isn'
Column type is username varchar(100).
When I do select from database:
"select * from user where username='John'"; //returns one row
"select * from user where username='john'"; //returns one row
The records in the database has username 'John'.
Why it isn't case sensitive? 'John"