[EMAIL PROTECTED] wrote: > This is what I thought: I have three entries: > 12. afan, pasalic, afan_at_afan_dot_net, 2003-12-18 > 13. Afan, Pasalic, Pasalic_at_yaoo_dot_com, 2001-01-01 > 14. AFAN, PASALIC, ammtar_at_gamil_dot_com, 2003-12-18 > > If I search for *afan* only entry no. 12 will be shown. > If I search for *Afan* only entry no. 13 will be shown. > If I search for *AFAN* only entry no. 14 will be shown.
Then the collation in use is either case sensitive or binary. To find all three entries you want a case insensitive collation – one with a name that ends in "_ci". I really recommend that you read the relevant part of the manual, and if you still have problems after that, return to this mailing list with a detailed question. http://www.mysql.se/doc/refman/5.0/en/charset.html Björn Persson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
