sql - Mysql DISTINCT not working in my language properly -

i have problem distinct in sql select. have table following values in column:

sítotisk sitotisk 

when use distinct - result "sítotisk" ...db system think, same word, need words have seperaly.

that's collation problem. guess you're using accent insensitive collation. can check in server/db/table properties.

try

select distinct yourcolumn collate utf8_bin ... 

you might want take @ these questions address same issue:

• how conduct accent sensitive search in mysql
• how mysql work “case insensitive” , “accent insensitive” in utf-8