Gordon Burditt wrote:
>>>> I've submitted a bug report (Bug #37439) titled
>>>> "Incorrect output order from ORDER BY using 2 field index in MEMORY BTREE".
>>>> I'm getting incorrectly ordered records out from a MEMORY database with
>>>> a two-field BTREE index. This fails in MySQL 5.0.27 on both Windows 2000 and
>>>> Fedora Core 5, two rather dissimilar systems.

I run everything in UTF-8 mode, with

ALTER DATABASE testdb DEFAULT CHARACTER SET utf8;

That changes the size of some items. Mind trying with that setting?
This thing is definitely size-sensitive. Thanks.

John Nagle