Case-insensitive LIKE in SQLite
Moderator: General Moderators
Case-insensitive LIKE in SQLite
Is there any way to perform case-insensitive LIKE, except using user defined REGEX-function?
Re: Case-insensitive LIKE in SQLite
http://www.sqlite.org/lang_expr.html wrote:Any other character matches itself or its lower/upper case equivalent (i.e. case-insensitive matching). (A bug: SQLite only understands upper/lower case for ASCII characters by default. The LIKE operator is case sensitive by default for unicode characters that are beyond the ASCII range. For example, the expression 'a' LIKE 'A' is TRUE but 'æ' LIKE 'Æ' is FALSE.)
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
Re: Case-insensitive LIKE in SQLite
Sorry, should mentioned that I'm using Unicode.s.dot wrote:http://www.sqlite.org/lang_expr.html wrote:The LIKE operator is case sensitive by default for unicode characters that are beyond the ASCII range. For example, the expression 'a' LIKE 'A' is TRUE but 'æ' LIKE 'Æ' is FALSE.)
Re: Case-insensitive LIKE in SQLite
The question is still active, can someone please help me?
I need case-insensitive search with SQL query in SQLite on Unicode encoding.
Is there any solution?
I need case-insensitive search with SQL query in SQLite on Unicode encoding.
Is there any solution?
Re: Case-insensitive LIKE in SQLite
Found myself, I think making both search string and column which is used in searching to lowercase will work fine.
Re: Case-insensitive LIKE in SQLite
Sometimes you just need regex too...
Re: Case-insensitive LIKE in SQLite
Shame there is no built-in REGEX in SQLite.josh wrote:Sometimes you just need regex too...
Re: Case-insensitive LIKE in SQLite
Sounds like it was not a powerful enough choice for a storage engine.
Re: Case-insensitive LIKE in SQLite
It's fine. This is the only problem I faced for 3 years.josh wrote:Sounds like it was not a powerful enough choice for a storage engine.
Re: Case-insensitive LIKE in SQLite
Once again, you need regex to do this. If your current database engine does not support regex, it is probably not possible. Look into a more robust database system. The fact you've used it for 3yrs doesn't change the fact it doesn't support regex, which is needed to do what you want.