In the last episode (Oct 14), bruce said:
> a basic/new/curious question. i have the following sample tbl schema.
> i do the following update on the mysql command line and it updates
> for both cases. my question is why???
>
> update UserTBL set gid='25', usertype='Super Administrator11' where
> username='ADmin';
> update UserTBL set gid='25', usertype='Super Administrator11' where
> username='admin';
>
> 'username' = 'admin' in the tabls...
Text fields are compared case-insensitively.
http://dev.mysql.com/doc/refman/4.1/en/case-sensitivity.html
--
Dan Nelson
dnelson@stripped
