How to sql search for the letter 'å'

Question

I'm trying to search through a MySQL table to find a specific column (as i have done many times before), but I have run into a problem, where I'm trying to search for the letter 'å', but it returns both a column with the letter 'å' and also a column with the letter 'a'.

for example.

I have a table named Categories that looks like this:

+----------+--------+
| Category | Answer |
+----------+--------+
|  cities  | abenra |
+----------+--------+
|  cities  | åbenrå |
+----------+--------+

When I then try to search through it like this SELECT * FROM Categories WHERE Category='cities' AND Answer='åbenrå' It returns the results:

+----------+--------+
| Category | Answer |
+----------+--------+
|  cities  | abenra |
+----------+--------+
|  cities  | åbenrå |
+----------+--------+

And what I was expecting and wanted was a result that looks like this:

+----------+--------+
| Category | Answer |
+----------+--------+
|  cities  | åbenrå |
+----------+--------+

So... How can I search for the letter 'å', without searching for the letter 'a' at the same time?

I really hope that you can help me! Thanks in regards.

Specify a Danish locale/collation etc? (In English, å is considered as a (strange) a.) — jarlh, Aug 11 '20 at 14:23
Try looking at this question: https://stackoverflow.com/questions/500826/how-to-conduct-an-accent-sensitive-search-in-mysql — Sean, Aug 11 '20 at 14:35
When searching "åbenrå" I only want "åbenrå" to be returned, not anything else — ThorBilsby, Aug 11 '20 at 14:58
But can't that Danish city be spelled both as Aabenraa and Åbenrå? — jarlh, Aug 11 '20 at 15:12
I'd consider one script only, for all spellings at the same time. — jarlh, Aug 11 '20 at 15:54

score 3 · Accepted Answer · answered Aug 11 '20 at 14:35

3

I guess you need to apply a conversion on your keyword for exact match

SELECT * FROM Categories 
WHERE Category='cities' 
AND Answer = CONVERT('åbenrå' USING binary)

DEMO

answered Aug 11 '20 at 14:35

M Khalid Junaid

63,861
10
90
118

How to sql search for the letter 'å'

1 Answers1