On 11.09.2010 20:42, Stef Mientki wrote:

> is there a program that converts sqlite database from windows-1252 to utf-8?

Yes, SQLiteSpy does this:

* Open database file
* Menu Execute -> Text to Unicode Conversion.
* Select tables and columns to convert.
* Choose database codepage.
* Press OK to start the conversion.

After conversion, browse the database contents to verify the result. As
SQLiteSpy supports Unicode text display and entry, you can do it right
there.

If you like what you see, execute "COMMIT" to store the conversion
changes. "ROLLBACK" in case of conversion errors and try again with a
different codepage.

Download: http://yunqa.de/delphi/doku.php/products/sqlitespy/index

Ralf
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to