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

159 user(s) are online (114 user(s) are browsing Support Forums)


Members: 0


Guests: 159


more...

Donat-O-Meter

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

Latest GitHub Commits