SQLITE3 / COLLATE without accents

aurigod · 01-04-2014, 09:05 AM

I want to filter characters with accents.
Is it possible to use COLLATE with a SQL request to Calibre Database?
I did not find the parameter UNICODE.
If you want to see the software I have made, send me a MP.
I do not know if allowed to post links to software.
I use it to seek in a closed database without launching Calibre.

eschwartz · 01-04-2014, 11:19 PM

linking to copyrighted software distributed without permission is a problem, but if you've created it yourself you certainly have the right to share it however you want, and as such there is no problem doing so here.

Many people have posted useful software (which they have the rights to) here at mobileread, to the betterment of the community.

kovidgoyal · 01-04-2014, 11:45 PM

SQLITE has no capability to do unicode collation, unless you compile it witht he icu extension. You'd need to ask elsewhere for help with doing that, as calibre does not use the sqlite icu extension.

aurigod · 01-05-2014, 05:01 AM

Thank you for the answer.

01-04-2014, 09:05 AM	#1
aurigod Enthusiast Posts: 40 Karma: 10 Join Date: Oct 2012 Location: Lyon [France] Device: JuliusvonJD	SQLITE3 / COLLATE without accents I want to filter characters with accents. Is it possible to use COLLATE with a SQL request to Calibre Database? I did not find the parameter UNICODE. If you want to see the software I have made, send me a MP. I do not know if allowed to post links to software. I use it to seek in a closed database without launching Calibre.

01-05-2014, 05:01 AM	#4
aurigod Enthusiast Posts: 40 Karma: 10 Join Date: Oct 2012 Location: Lyon [France] Device: JuliusvonJD	Thank you for the answer. Last edited by aurigod; 01-10-2014 at 03:35 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Where is file name in sqlite3 db?	Tomladams	Library Management	3	11-12-2012 02:31 PM
PRS-T1 Can't type accents?	carnivroar	Sony Reader	5	01-25-2012 02:10 PM
Accents	Dariarb	Library Management	5	01-22-2012 05:29 PM
Accents On MacOSX 10.6	SirMcLouis	Calibre	0	06-27-2010 04:35 PM
Firstname as author - metadata.db and SQLite3	Starson17	Calibre	11	12-20-2009 02:01 PM

01-04-2014, 11:19 PM	#2
eschwartz Ex-Helpdesk Junkie Posts: 19,422 Karma: 85397180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	linking to copyrighted software distributed without permission is a problem, but if you've created it yourself you certainly have the right to share it however you want, and as such there is no problem doing so here. Many people have posted useful software (which they have the rights to) here at mobileread, to the betterment of the community.

01-04-2014, 11:45 PM	#3
kovidgoyal creator of calibre Posts: 43,850 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	SQLITE has no capability to do unicode collation, unless you compile it witht he icu extension. You'd need to ask elsewhere for help with doing that, as calibre does not use the sqlite icu extension.

Advert