Jump to content

Archived

This topic is now archived and is closed to further replies.

lilywong

Differentiate small and capital letter

Recommended Posts

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.

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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\" /]

:)

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.