List:General Discussion« Previous MessageNext Message »
From:Björn Persson Date:November 20 2005 11:59pm
Subject:Re: case insensitive search
View as plain text  
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
Thread
one product in more categoriesafan@afan.net18 Oct
  • Re: one product in more categoriesSGreen18 Oct
    • Re: one product in more categoriesafan@afan.net18 Oct
    • Re: one product in more categoriesafan@afan.net18 Oct
      • Re: one product in more categoriesPeter Brawley18 Oct
        • Re: one product in more categoriesafan@afan.net19 Oct
          • Re: one product in more categoriesafan@afan.net19 Oct
          • Re: one product in more categoriesPeter Brawley19 Oct
          • Re: one product in more categoriesSGreen19 Oct
            • Re: one product in more categoriesafan@afan.net20 Oct
              • Re: one product in more categoriesPeter Brawley20 Oct
                • Re: one product in more categoriesafan@afan.net20 Oct
                  • Re: one product in more categoriesPeter Brawley21 Oct
              • Re: one product in more categoriesSGreen21 Oct
                • Re: one product in more categoriesafan@afan.net21 Oct
                  • Re: one product in more categoriesSGreen21 Oct
    • Re: one product in more categoriesRhino18 Oct
  • Re: one product in more categoriesRhino18 Oct
    • case insensitive searchafan@afan.net19 Nov
      • Re: case insensitive searchJasper Bryant-Greene19 Nov
        • Re: case insensitive searchafan@afan.net20 Nov
          • Re: case insensitive searchBjörn Persson21 Nov
      • Re: case insensitive searchScott Haneda19 Nov
      • Re: case insensitive searchBjörn Persson19 Nov