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. 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] 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. 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. 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 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\" /]:) 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
Archived
This topic is now archived and is closed to further replies.