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 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" and 'john' .. are two different > strings..? > ----------------------------------------------------------------------- Grover Manuel Campos Ancajima Ingeniero de Desarrollo Dictuc - Pontificia Universidad Católica de Chile http://www.dictuc.cl Telf. Of. +56(2)3544441 Telf. Cel. +5691415436
