Convert Mysql to Sqlite database

Question

I have a MySql database with different language(English, Hindi, Tamil,...) contents, to convert it into sqlite I have to run this (http://www.jbip.net/content/how-convert-mysql-sqlite) Script. When I export the mysql db with this command mysqldump -u root -p --compatible=ansi --skip-opt generator > dumpfile contents other than english are displays like ?????. How can I export the database to support all language contents. Please help me Or suggest me other way to convert mysql database to sqlite . Thanks in advance.......

newtover · Accepted Answer · 2011-11-16 05:36:50Z

4

If you are sure that the data in the database is correctly encoded, just add --default-character-set=utf8 to the mysqldump options.

answered Nov 16, 2011 at 5:36

newtover

32.2k11 gold badges89 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert Mysql to Sqlite database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related