Mysql DISTINCT not working in my language properly

Question

I have a problem with DISTINCT in SQL select. I have table with following values in column:

sítotisk
sitotisk

when I use DISTINCT - so the result is only "sítotisk" ...db system think, that is the same word, but i need the words have seperaly.

please elaborate your question and post your code, what you have to tired ? — mja, Dec 16 '14 at 08:42

score 2 · Accepted Answer · edited May 23 '17 at 11:50

2

That's a collation problem. I guess you're using an accent insensitive collation. You can check that in your server/DB/table properties.

Try

SELECT DISTINCT yourColumn COLLATE utf8_bin
FROM ...

You might want to take a look at these questions that address the same issue:

edited May 23 '17 at 11:50

Community

answered Dec 16 '14 at 08:42

xlecoustillier

Thank you for lead - the right collate was COLLATE utf8_bin – Václav Veselka Dec 16 '14 at 09:01
Yes, I was confused at first with sql server collations :) – xlecoustillier Dec 16 '14 at 09:02

1 Answers1