0003209: Internal problem of Database sorting

ID	Project	Category	View Status	Date Submitted	Last Update

0003209	MMW v4	DB/FileMonitor	public	2007-06-29 13:19	2007-06-29 13:20

Reporter	jiri	Assigned To
Priority	urgent	Severity	minor	Reproducibility	always
Status	resolved	Resolution	fixed
Product Version	3.0
Fixed in Version	3.0

Summary	0003209: Internal problem of Database sorting
Description	Currently we supply SQLite with the way how to sort strings in database and we do it according to user's locale setting (i.e. different order for English or Czech users). This however causes a potential problem - if user switches to another locale, or even uses one database from two computers with different locales, DB indexes can become corrupted with unpredictable results.
Tags	No tags attached.

Fixed in build	1046

jiri 2007-06-29 13:20 administrator ~0009617	Fixed in build 1046. - It's fixed now by sorting everything using standard English order in database. Note, that it shouldn't have any impact on the user, all visible data should be properly sorted by MM so that they are according to the user's locale.