Eliminating Duplicate rows in Postgres

Question

I want to remove duplicate rows return from a SELECT Query in Postgres

I have the following query

SELECT DISTINCT name FROM names ORDER BY name

But this somehow does not eliminate duplicate rows?

Answer 1

Maybe something with same-looking-but-different characters (like LATIN 'a'/CYRILLIC 'а')