Re: [sqlite] is there a program that converts sqlite database from windows-1252 to utf-8 ?
thanks Ralf, nice db-browser, and conversion seems to work. cheers, Stef On 13-09-2010 11:03, Ralf Junker wrote: > 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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] is there a program that converts sqlite database from windows-1252 to utf-8 ?
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
Re: [sqlite] is there a program that converts sqlite database from windows-1252 to utf-8 ?
> > is there a program that converts sqlite database from windows-1252 to utf-8 > ? > It the base is not big, I think you can dump the db to sql file with the sqlite shell, convert this text file to UTF-8 (even with notepad) and feed it to new db Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] is there a program that converts sqlite database from windows-1252 to utf-8 ?
thanks Stef Mientki ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users