For some applications it is, for others not in all cases. For "just" accented characters it should be no problem following these instructions. General advice: download OpenOffice or similar OpenSource packages. They are completely free and support almost all OS's.
Kind regards | Vriendelijke groeten | Cordiali saluti, Klaas `Z4us` van Buiten V, Experienced Freelance ICT-Guy https://www.linkedin.com/in/klaas-van-buiten-0325b2102 -------------------------------------------- On Mon, 19/6/17, Klaas Van B. <klaasva...@yahoo.com> wrote: Subject: Re: How to search for fields with accents in UTF-8 data? To: "SQLite Maillist" <sqlite-users@mailinglists.sqlite.org> Cc: "CC" <codecompl...@free.fr> Date: Monday, 19 June, 2017, 8:41 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
