lilywong Posted May 30, 2006 Share Posted May 30, 2006 for example in table student as below:=================StudentNameJoeJimmyMary=================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. Quote Link to comment https://forums.phpfreaks.com/topic/10744-differentiate-small-and-capital-letter/ Share on other sites More sharing options...
poirot Posted May 30, 2006 Share Posted May 30, 2006 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] Quote Link to comment https://forums.phpfreaks.com/topic/10744-differentiate-small-and-capital-letter/#findComment-40135 Share on other sites More sharing options...
lilywong Posted May 30, 2006 Author Share Posted May 30, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/10744-differentiate-small-and-capital-letter/#findComment-40159 Share on other sites More sharing options...
poirot Posted May 30, 2006 Share Posted May 30, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/10744-differentiate-small-and-capital-letter/#findComment-40164 Share on other sites More sharing options...
lilywong Posted May 30, 2006 Author Share Posted May 30, 2006 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 Quote Link to comment https://forums.phpfreaks.com/topic/10744-differentiate-small-and-capital-letter/#findComment-40182 Share on other sites More sharing options...
ale_jrb Posted May 30, 2006 Share Posted May 30, 2006 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\" /]:) Quote Link to comment https://forums.phpfreaks.com/topic/10744-differentiate-small-and-capital-letter/#findComment-40192 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.