Hello to all, I've noticed several problems regading behaviour of indexes in MySQL 4.1 MySQL seems to ignore encoding settings for the database. When I request sorted dataset, it is returned incorrectly when indexes are used. My data is stored in cp1251 encoding.
consider this: SELECT * FROM table_name ORDER BY column_name returns dataset sorted incorrectly when table_name has index on column_name, while SELECT * FROM (SELECT * FROM table_name) ORDER BY column_name returns absolutely correct order. Is it possible to fix in the current version, or it is kind of a known bug? Thanks in advance!
