Sqlite regex case insensitive9/4/2023 Or you could put that line into your /.sqliterc. To be able to use it, you have to load it each time you open the database. If you want only part of the regex to be case insensitive (as my original. which implements Perl regular expressions in a loadable module in /usr/lib/sqlite3/pcre.so. Nearly all regex engines support it: /G a-b./i string.match ('G a-b.', 'i') Check the documentation for your language/platform/tool to find how the matching modes are specified. custom collate) instead, if it is possible in my case. Assuming you want the whole regex to ignore case, you should look for the i flag. This approach seems to be satisfying, but I wanted to get the elegant solution (i.e. The best lead I have so far would be to create a custom column without accents as described here. However, I haven't seen a single written example achieving this kind of accent/case insensitive search.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |