Sorting a table half cyrillic half latin

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Wentu
Forum Newbie
Posts: 11
Joined: Sun Feb 02, 2003 1:09 pm

Sorting a table half cyrillic half latin

Post 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
Post Reply