Nobody/Anonymous - 2008-06-10

Hi all,

I am investigating why my Cyrillic (Russian) field values (artist, file name, title etc). cannot be found in SQL page. Elsewhere, they seem to work fine.

What I found is this. All non-latin characters (i.e. those taking more than one byte when encoded to utf8) are stored in mysql tables with wrong byte order. So, if I try performing a query like "SELECT * FROM tracks WHERE Artist like "%john%", it is working, but "SELECT * FROM tracks WHERE Artist like "%иван%" comes empty.

If I look directly in mysql tables, Cyrillic "A" is stored as "90 d0" instead of "d0 90".

Also, if I store correct utf8 string in any table, it comes as "?????" in prokyon3 UI.

Any ideas?

Alex Emelianov