CC wrote:
> 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.
The latest version of sqlite3.exe might work.
Anyway, to check that whatever tool you're using uses Unicode correctly,
execute this:
SELECT char(206), unicode('Î');
This should output Î and 206.
> ;Returns the expected records
> SELECT COUNT(*) FROM MyTable WHERE "LIBREG" LIKE "%le-de-France";
Does "SELECT unicode(Libreg) FROM MyTable WHERE Libreg LIKE '%le-de-France'
LIMIT 1"
return the correct code?
> 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.
The database API always uses Unicode.
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
