MySQL Bugs: #21347: hebrew utf8 ORDER BY produces bad results in OpenBSD MySQL 5.0

Bug #21347	hebrew utf8 ORDER BY produces bad results in OpenBSD MySQL 5.0
Submitted:	30 Jul 2006 9:36	Modified:	29 Jun 2007 11:25
Reporter:	Jay Gay	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	5.0	OS:	Any (Linux, OpenBSD)
Assigned to:	Georgi Kodinov	CPU Architecture:	Any
Tags:	hebrew, order by, utf8

File:	Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

On *nix platforms use the split command e.g. split -b 50MB <my_large_archive> <my_split_archive_prefix>
On windows use WinZip or a similar utility to split the large file

The above list in the correct Hebrew order (added a column referancing the original one)

Attachment: correct order.pdf (application/pdf, text), 15.87 KiB.

test case

Attachment: bug21347.test (application/octet-stream, text), 503 bytes.

Test with corrected connection collation

Attachment: bug21347.test (application/octet-stream, text), 546 bytes.

a script that produces correct results

Attachment: bug.test (, text), 735 bytes.