SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    Aug 2002
    Location
    Barcelona
    Posts
    43
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to treat German characters as their "normal" equivalent?

    I'd really appreciate suggestions as to how to get MySQL to treat e.g. "ü" as "u" etc. I want to be able to search for e.g. "muller" and get both "muller" and "müller" to appear in the results.

    I´ve been banging my head on the wall for a few days on this one, so all comments much appreciated!

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,262
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Enthusiast
    Join Date
    Aug 2002
    Location
    Barcelona
    Posts
    43
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the reply. I didsee it, but I´m not sure how it could help me:

    It still appears to mean that a search for "muller" would not find "müller". Moreover, a search for "müller" would not match "muller" as it would look for matches to "mueller" instead. And to top it off, a search for "mueller" does not find "müller"!

    Also, it says "When comparing strings with LIKE, the one-character to two-character mapping is not done. All letters are converted to uppercase. Accents are removed from all letters except Ü, ü, Ö, ö, Ä, and ä. "

    It is precisely that last sentence which is causing me problems! I need it to remove those accents, like it does for "é" and "è"...like I said, this is a real headache!


Bookmarks

Posting Permissions

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