Bug 16700 – Sorting of non-ASCII characters broken on Windows

Bug 16700 - Sorting of non-ASCII characters broken on Windows

Summary:

Sorting of non-ASCII characters broken on Windows

Status:	CLOSED FIXED

Product:	Logitech Media Server
Classification:	Unclassified
Component:	Database
Version:	7.6.0
Platform:	PC Windows XP

Importance:	-- major (vote)
Target Milestone:	7.6.0
Assigned To:	Andy Grundman

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2010-12-10 05:52 UTC by Alan Young
Modified:	2011-05-10 14:33 UTC (History)
CC List:	1 user (show)

See Also:
Category:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Alan Young 2010-12-10 05:52:38 UTC

Bug 14800 has been resolved for Lunix (and presumably OSX) platforms but this problem still exists for Windows.

The database stores text fields in UTF-8 encoding but Windows locales do not support sorting UTF-8-encoded strings.

Comment 1 Andy Grundman 2010-12-10 05:54:28 UTC

Will investigate building DBD::SQLite with ICU support.

Comment 2 SVN Bot 2010-12-14 05:39:27 UTC

 == Auto-comment from SVN commit #31635 to the slim repo by ayoung ==
 == http://svn.slimdevices.com/slim?view=revision&revision=31635 ==

bug 16700: Sorting of non-ASCII characters broken on Windows 
Update LOCALE names for Windows

Comment 3 Andy Grundman 2010-12-14 08:45:36 UTC

DBD::SQLite now has ICU support on all platforms, providing correct sorting for all database queries.

Comment 4 Bradley D. Wall 2011-05-10 14:33:19 UTC

Fixed in build 7.6, 32302.
Closing