You can even make UTF-8 the default encoding in Windows as it is in SQLite https://superuser.com/questions/239810/setting-utf8-as-default-character-encoding-in-windows-7
CC <codecompl...@free.fr> wrote on Sun, 18 Jun 2017 12:52:33 +0200: >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? Kind regards | Vriendelijke groeten | Cordiali saluti, Klaas `Z4us` van Buiten V, Experienced Freelance ICT-Guy https://www.linkedin.com/in/klaas-van-buiten-0325b2102 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
