On 13 Jul 2016, at 5:54pm, S.Ajina <s.ajina2...@gmail.com> wrote: > SQLite version 3.13.0 2016-05-18 10:57:30
> Jap�n (2002)|4A6170C3B36E20283230303229 > 4A 61 70 C3 B3 6E 20283230303229 > SQLite version 3.8.6 2014-08-15 11:46:33 > Japón (2002)|4A6170C3B36E20283230303229 > 4A 61 70 C3 B3 6E 20283230303229 The fourth character in both cases is encoded as C3 B3 which is the correct UTF-8 encoding for LATIN SMALL LETTER O WITH ACUTE . So the database is identical in both cases. It's just that the 3.13.0 shell tool isn't displaying the contents correctly. I don't know Windows enough to know what to do next. Does it make any different if you issue the "codepage 65001" command before starting the 3.13.0 shell to use the SELECT command ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users