Page 1 of 1

Sorting a table half cyrillic half latin

Posted: Sun Apr 20, 2003 4:23 pm
by Wentu
I have a table representing something like a dictionary. One column is in cyrillic, the other in latin ( other columns do not care about character set ).
I'd like to be able to sort this table using both alphabet. IS that possible ?

Now, from this table i also create two table, one with only russian words ( then cyrillic ) and the other with italian words (hence, good old latin ).
Is it possible to sort the cyrillic table ? I am having problem and reading here and there i understood that it's some problem with the charset used by mysql. What does this prevent ? only sorting, or also selecting ?
From some experiments i tried, it seems to me that also selecting has some problems, is that possible ?
How do i manage multiple charsets in PHP-MySQL ?

thank you so much

Wentu