Case insensitive search #206
Comments
|
It shouldn't be, but I see now that the function Could you provide me with some test cases, e.g upper case strings and lower case equivalents? |
|
Sure. |
|
I tested and discovered that this isn't a bug, but a restriction of current Sqlite distributions (the database that Calibre uses). By default it works with ASCII. To change that you would have to load an extension enabling Unicode. Unfortunately that extension isn't included in most installations. I'll try to find a workaround. |
The standard SQLite distribution doesn't work fully with Unicode texts, eg functions like lower and upper don't transform Unicode strings properly. Sincle loading the ICU extension for SQLite -- which could solve this problem -- seems to be a problem with most distributions currently, there is now a workaround that transform the search expression into lower- and title-case forms, and then uses both to search for items. Unicode names that were not transformed into lower case should be matched (mostly) by the title-case search expression.
|
There is now a workaround that could help. Could you please test this version? |
The search in non-English languages (e.g. Russian) is case sensitive. Can it be changed to be case insensitive, please?
The text was updated successfully, but these errors were encountered: