Hello
I imported a CSV file where data are encoded in UTF-8.
Some of the characters (like Î) are not available in the ASCII table, so
I can't use the CLI sqlite3.exe to search.
As an alternative, I tried SQLite Studio, but it fails:
;Returns no record
SELECT COUNT(*) FROM MyTable WHERE REGION="Île-de-France";
;Returns the expected records
SELECT COUNT(*) FROM MyTable WHERE "LIBREG" LIKE "%le-de-France";
I found nothing in SQLite Studio's menus that could be related to
encoding so that I could tell it the DB contains UTF-8 instead of ANSI.
Is there another Windows application I could try that is more likely to
work with UTF-8 data?
Thank you.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
