The idea I tried to convey was that you have all locale queries created:
Example:
Code:
SELECT * FROM authors ORDER BY name COLLATE POLISH;
SELECT * FROM authors ORDER BY name COLLATE SPANISH;
SELECT * FROM authors ORDER BY name COLLATE FRENCH;
.............
When you install calibre you select a language so from them on the queries launched against the database would use the language collation that you are using in the interface. It seems quite logic.
To summarize, is this SQLite/database-based approach possible?
Code:
calibre_lang = German // Or English, or korean, or whatever
db_query = SELEC foo, bar, baz ... whatever COLLATE $calibre_lang