CODEWITHSUNDEEP
javamysqldatabasesqlite
selva
selva

Reputation: 444

Convert Mysql to Sqlite database

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.......

Upvotes: 1

Views: 1476

Answers (1)

newtover
newtover

Reputation: 32094

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

Upvotes: 4

Related Questions