Moved to www.ahkscript.org. Support will be continued there.
Edited by just me, 19 December 2013 - 09:23 AM.
Moved to www.ahkscript.org. Support will be continued there.
Edited by just me, 19 December 2013 - 09:23 AM.
Works":yqk5jf6v">SELECT * FROM Test WHERE Name LIKE 'Näme%'
Does not work - [charlist">wildcards":yqk5jf6v]SELECT * FROM Test WHERE Name LIKE 'N[aä]me%'
Another solutions that work":yqk5jf6v">SELECT * FROM Test WHERE Name LIKE 'Name%' OR Name LIKE 'Näme%'
SELECT * FROM Test WHERE Name LIKE 'N_me%'
Case-insensitive matching of Unicode characters is a MUST HAVE for me. So should I use SQLite or not than? How to deal with it?Case-insensitive matching of Unicode characters does not work.
Now, if I want to find all rows containing đorđe string in FName column, and use case-insensitive matching, my statment should look like thisINSERT INTO Test Values('Marko','Đorđević','','')
INSERT INTO Test Values('Ivan','Karađorđević','','')
INSERT INTO Test Values('Pero','KarađorĐević','','')
Right? Is there any better way to deal with case-insensitive matching of unicode characters?SELECT * FROM Test WHERE FName LIKE '%ĐorĐe%' OR FName LIKE '%đorĐe%' OR FName LIKE '%Đorđe%' OR FName LIKE '%đorđe%'
which matches đorđe, sorđe, morže, žorže, (etc. thousands of possible matches), and than filter results with AHK - remove all results than don't match đorđe (case-insensitive, of course)SELECT * FROM Test WHERE FName LIKE '%_or_e%'
may be mistakable, I'm not an expert in SQLite, my project is the wrapper class. But trying to answer your question:...with one of my favorite projects: SQLite.
Hardware: fast laptop with SSD
Software: Win 7 Home Premium 64-bit, android for phone and tablet
Under which licence is this code released?
Under which licence is this code released?
It doesn't matter because the license wouldn't stand up to scrutiny in any court. Next.
Moin IsNull,
ich möchte nicht, dass Du den Code von "[Class] SQliteDB" hier verwendest. Würdest Du also bitte so nett sein, Deine eigene Interpretation selbst zu schreiben?
en:
Hello IsNull
I don't want you to use my SQliteDB wrapper code in your code. Would you be so kind to write your own wrapper library?
Source
I am only going to nitpick about your assumption that pointers are always 4 bytes and fit in an UInt.