sqlite db query error

Beta Testing for Windows Products and plugins

Moderator: Gurus

sqlite db query error

Postby llcj » Tue Mar 06, 2007 5:00 pm

Hi all,

I installed mediamonkey 3.0 alpha 2 and I'm querying the new database with a simple query using SQLite2007 Pro. I renamed the mediamonkey database to mm.db3 and opened it. Then I ran a query "select * from artists order by id". This runs as expected... However, if I try to run "select * from artists order by artist", the query errors out with: "no such collation sequence: IUNICODE". Is this a limitation with my query program or a bug affecting mediamonkey... or do I need to change my query in some way??? I have many mp3 songs and artists that use foreign characters. I've been able to run queries under mediamonkey 2.5 easily but I'm new to this sqlite engine.
C# n00b enthusiast
llcj
 
Posts: 2
Joined: Wed Jan 31, 2007 3:19 pm

Postby onkel_enno » Wed Mar 07, 2007 1:17 am

I get this stupid IUNICODE-Message too and still down't know how to fix that.

Maybe one of the developers could tell us how to define this collation sequence within the DB. I haven't time for SQLite at the moment to find it out by my self :(

As long as I can't manipulate the DB, I can't switch to MM3. There's too much work in my old DB.
SansaMonkey - for SanDisk Sansa and Rockbox Users

Please no PMs for Questions which should be asked in the Forum. Thx
onkel_enno
 
Posts: 2145
Joined: Fri Jan 14, 2005 1:45 am
Location: Germany

Postby jiri » Wed Mar 07, 2007 5:04 am

IUNICODE collation is defined by MM for the SQLite database in order to specify case insensitive sort order for Unicode characters. I'm not aware of other method how to achieve this and I'm also not sure how to force other applications to properly open the database, please let us all know here if you find anything.

Jiri
jiri
 
Posts: 5290
Joined: Tue Aug 14, 2001 7:00 pm
Location: Czech Republic

Postby onkel_enno » Wed Mar 07, 2007 5:46 am

I thought something like that.
How do you define it within MediaMonkey/Delphi?
SansaMonkey - for SanDisk Sansa and Rockbox Users

Please no PMs for Questions which should be asked in the Forum. Thx
onkel_enno
 
Posts: 2145
Joined: Fri Jan 14, 2005 1:45 am
Location: Germany

Postby jiri » Thu Mar 08, 2007 9:03 am

It's done using SQLite API function SQLite3_CreateCollation16().

Jiri
jiri
 
Posts: 5290
Joined: Tue Aug 14, 2001 7:00 pm
Location: Czech Republic

Postby onkel_enno » Thu Mar 08, 2007 9:29 am

Thanks a lot :lol:
SansaMonkey - for SanDisk Sansa and Rockbox Users

Please no PMs for Questions which should be asked in the Forum. Thx
onkel_enno
 
Posts: 2145
Joined: Fri Jan 14, 2005 1:45 am
Location: Germany


Return to MediaMonkey for Windows 4 Beta Testing

Who is online

Users browsing this forum: No registered users and 6 guests