afan@stripped 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
