1
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
