Skip to content

Does the out-of-the-box version support case-insensitive search by Cyrillic characters? #1201

Answered by Prinzhorn
krutoo asked this question in Q&A
Discussion options

You must be logged in to vote

Does the out-of-the-box compilation of sqlite support case-insensitive Cyrillic search?

I've put this verbatim into Google, first result:

https://stackoverflow.com/questions/3465118/nhibernate-sqlite-and-cyrillic-characters-case-sensitivity-and-fallback-queri

leads to

https://www.sqlite.org/faq.html#q18

which says

The default configuration of SQLite only supports case-insensitive comparisons of ASCII characters. The reason for this is that doing full Unicode case-insensitive comparisons and case conversions requires tables and logic that would nearly double the size of the SQLite library. The SQLite developers reason that any application that needs full Unicode case support probably al…

Replies: 2 comments 3 replies

Comment options

You must be logged in to vote
3 replies
@krutoo
Comment options

@krutoo
Comment options

@Prinzhorn
Comment options

Answer selected by mceachen
Comment options

You must be logged in to vote
0 replies
# for free to join this conversation on GitHub. Already have an account? # to comment
Category
Q&A
Labels
None yet
3 participants