locked
Search engine with support of accents or not RRS feed

  • Question

  • User1456405545 posted

    Hi,

    I have to make a search engine who search in a MySQL database in a "Name" column.

    The problem is that my "Name" column contains entries with accents (I am French).

    I want that if someone searches the name "Nestlé", the function searches for the words "Nestlé" but also "Nestle", "nestle" ... the case should not be a problem.

    For nowthe only solution found is to have a column "Tags", same as "Namebut without the accentsWith over 12,000 entriesthe duplicate column is problematic for space and redundancy handling.

    My first idea was to change the search entry for it ignores accents but I do not see how.

    Thank you in advance
    Tuesday, February 14, 2012 10:49 AM

Answers

  • User-633481390 posted

    Perhaps this Stackoverflow post would help - http://stackoverflow.com/questions/7126527/problem-with-accent-insensitive-searches

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, February 14, 2012 1:43 PM

All replies

  • User-633481390 posted

    Perhaps this Stackoverflow post would help - http://stackoverflow.com/questions/7126527/problem-with-accent-insensitive-searches

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, February 14, 2012 1:43 PM
  • User1456405545 posted

    Thanks, I will search in this direction tomorrow at work, I don't remember in what collation my DB is for now.

    EDIT : The collation utf8_general_ci can search with or without accents. Thanks a lot

    Tuesday, February 14, 2012 5:31 PM