Differentiate small and capital letter

[lilywong]

for example in table student as below:

=================
StudentName
Joe
Jimmy
Mary
=================
in this case, Mary already stored in the table, so the system does not allow user to key in mary, as we want to treat Mary and mary to be the same, any idea ?

thanks.

[poirot]

You might want to use [a href=\"http://www.php.net/ucfirst\" target=\"_blank\"]ucfirst()[/a], [a href=\"http://www.php.net/ucwords\" target=\"_blank\"]ucwords()[/a], [a href=\"http://www.php.net/strtoupper\" target=\"_blank\"]strtoupper()[/a] or [a href=\"http://www.php.net/strtolower\" target=\"_blank\"]strtolower()[/a]

[lilywong]

can i set this in my database side ?
i'm using MySQL as db, can i do some setting there so that i will automatically recgnized J and j is the same.
thanks.

[poirot]

I don't think so. But you can use it prior to adding info to the database.
Just set the field "UNIQUE" so it there will be no repeated data.

[lilywong]

i am using mySQL Front, but i couldn't find a way to set the field to unique.
any sql example to show me ? thanks

[ale_jrb]

The unqiue option is shown here when you create a table, and in turn, fields:

[img src=\"http://img123.imageshack.us/img123/5927/mysqlfront0na.png\" border=\"0\" alt=\"IPB Image\" /]

:)