paschim Posted September 2, 2008 Share Posted September 2, 2008 Well, i don't know if this is supposed to happen or there is a mistake somewhere, but say i try to run a query where name='zoro', it returns rows for zoro, Zoro, zOro,.... any idea whats happening? I can obviously run a check in later part of code....but isn't there any way to just return rows for exactly that particular name? i mean case-sensitive search? Link to comment https://forums.phpfreaks.com/topic/122464-solved-selecting-case-sensitive/ Share on other sites More sharing options...
tmbrown Posted September 3, 2008 Share Posted September 3, 2008 im not entirely sure how you would do this. however if it is a username and password, require that the username matches with its password, or use the same technique within other fields. usually unique id's take care of this problem. howver i cant really say ive had a problem with case sensitivity before. Link to comment https://forums.phpfreaks.com/topic/122464-solved-selecting-case-sensitive/#findComment-632346 Share on other sites More sharing options...
PFMaBiSmAd Posted September 3, 2008 Share Posted September 3, 2008 http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html Link to comment https://forums.phpfreaks.com/topic/122464-solved-selecting-case-sensitive/#findComment-632364 Share on other sites More sharing options...
fenway Posted September 3, 2008 Share Posted September 3, 2008 Alternatively, use a collation that is case sensitive. Link to comment https://forums.phpfreaks.com/topic/122464-solved-selecting-case-sensitive/#findComment-632386 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.