lundi 14 décembre 2015

Sqlite3 Encoding issue - html output generated from DB contains garbled text

I am using sqlite to export from a DB to an html file. My bash code is below:

./sqlite3 -batch dbfilename.db <<EOF
.output myoutputfile.html
.headers off
.mode html
select * from issues;
EOF

Characters like - or ' appear garbled in the output file. However if I run sqlite on the file and run the select they show up fine in shell output.

Thank you

Aucun commentaire:

Enregistrer un commentaire