If you are on Windows, you can use SQLiteSpy to correct such wrongly
entered ANSI text to Unicode throughout an entire database:
http://yunqa.de/delphi/products/sqlitespy/index
Open the database and from the menu pick
Execute -> Text to Unicode Convertsion ...
A dialog opens where you can check and uncheck the tables and columns to
convert. Next choose the "Current Database Codepage". This should be the
codepage of the wrongly entered text and defaults to your system
codepage. If unsure, use an educated guess or try different codepages.
Press OK to execute the conversion. For safety, all changes are by
default performed within a transaction. The dialog closes when done and
can browse the tables to check the changes. Depending on the outcome, at
last manually COMMIT or ROLLBACK.
Ralf
On 23.06.2016 18:16, Hick Gunter wrote:
Your data entry device (I guess a PC running a flavor of windows) is
generating a certain sequence of bytes when you press ALT+225. This
sequence is probably ISO/ANSI encoded instead of UTF-8 encoded. It
has nothing to do with sqlite itself. Sqlite will faithfully
reproduce whatever byte sequence you gave to it.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
