#1032 On the fly query collation setting in sorted browse mode

[Ondřej Zarevúcky]

Hi,
I'm working with database containing many different languages, so my collation is set to "utf8_general_ci". But when I browse the tables in phpMyAdmin, I'd like to be able to set sorting collation when sorting by text fields.

Example:
- Query SELECT id, text, language FROM table WHERE language = 'cs_cz';
- Then sort the string by text column. phpMyAdmin changes the query to:
SELECT id, text, language FROM table WHERE language = 'cs_cz' ORDER BY text ASC;
- I'd like to by able to select collation for this sort without manually changing the query to:
SELECT id, text, language FROM table WHERE language = 'cs_cz' ORDER BY text COLLATE utf8_czech_ci ASC;