mercredi 3 février 2016

sqlite3 .read command not working with unicode script

I used command .read script.sql (of command line tool sqlite3.exe that I've downloaded from http://ift.tt/1AMdXmL) to import data to an existing database sqlite. File script.sql was saved with notepad++ in encoding UTF8 without BOM, has content like this:

INSERT INTO "table1" VALUES('Các con cáo nâu nhanh chóng nhảy chó lười biếng');
INSERT INTO "table1" VALUES('速い茶色のキツネは、のろまなイヌに飛びかかっ');
INSERT INTO "table1" VALUES('빠른 갈색 여우가 게으른 개 점프');

But after I ran above command, data was convert to ansii, like this:

Các con cáo nâu nhanh chóng nhảy chó lưá»i biếng
速ã„茶色ã®ã‚­ãƒ„ãƒã¯ã€ã®ã‚ã¾ãªã‚¤ãƒŒã«é£›ã³ã‹ã‹ã£
ë¹ ë¥¸ 갈색 여우가 게으른 ê°œ ì 프

Does anybody know how to solve the problem?

Aucun commentaire:

Enregistrer un commentaire