Hi, Ralf, On Thu, Jun 23, 2016 at 12:38 PM, Ralf Junker <ralfjun...@gmx.de> wrote: > If you are on Windows, you can use SQLiteSpy to correct such wrongly entered > ANSI text to Unicode throughout an entire database:
It is not wrongly entered text. I am using Windows with English locale only. So what I'm trying to do is to see what will happen if I get a database with the German character(s) or Asian characters in the table/field name and they will be entered the same way. My program will probably try to open on the same machine or at least on the machine with the same locale, but nevertheless, it should be possible to get the information I want. Thank you for the suggestion though. > > 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
