Results 1 to 3 of 3

Thread: DB search

  1. #1
    Join Date
    Jul 2009

    Unanswered: DB search


    I am sure it is VERY simple but sometimes we can't see it.

    I have a table with NAMES and PHONES

    Then I want to have a search on my web page, "look for specific names".

    The site charset = iso-8859-1 (portuguese-br)

    so when a user uploads his name and number, on the DB it saves like this (with accents)

    NAME ---------------- NUMBER

    Joăo ----------------- 12345678
    Rámon --------------- 87654321

    when I do the search, if I write Joao (without the accent) I dont get results, any help ?

  2. #2
    Join Date
    Sep 2009
    San Sebastian, Spain
    Have a look at either the MySQL function SOUNDEX or the following link Common MySQL Queries for Levenshtein which is another popular comparison.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    Follow me on Twitter

  3. #3
    Join Date
    Jul 2009
    thanks, starting to get there

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts