Sorting a table half cyrillic half latin
Posted: Sun Apr 20, 2003 4:23 pm
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
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