1
highlander
mysql search for 'funny' characters
  • 2005/11/27 11:58

  • highlander

  • Not too shy to talk

  • Posts: 151

  • Since: 2004/12/5


Hi All,

How would I let MySQL search for words starting with a 'strange' character ?

SELECT name FROM table WHERE name LIKE 'A%'

returns all the names that start with an A. (duh)

SELECT name FROM table WHERE name LIKE 'Å%'

returns all the names that start with an Å. (good)

SELECT name FROM table WHERE name LIKE 'À%'

returns all the names that start with an A. (strange)

Is there a way to get consistent results ? ie seaching for an À should give me an À and not an A ??

Hope someone can point me in the right direction.

greetings Highlander
So, I'm in the park wondering why frisbees get larger as they get closer when suddenly, it hits me...
www.AnimalPedigree.com

Login

Who's Online

158 user(s) are online (112 user(s) are browsing Support Forums)


Members: 0


Guests: 158


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits