Hi, Gunter, On Thu, Jun 23, 2016 at 12:16 PM, Hick Gunter <h...@scigames.at> 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.
Yes, it is a PC (a laptop with Windows). OK, I understand and its unfortunate, but that's life. Now the question is: what is the best way to fix it? From the link I posted it sounds like there is a byte sequence before the string, which identifies the encoding. Will this help? Thank you. > > -----Ursprüngliche Nachricht----- > Von: sqlite-users-boun...@mailinglists.sqlite.org > [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Igor > Korot > Gesendet: Donnerstag, 23. Juni 2016 17:58 > An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Betreff: Re: [sqlite] Conversion failure > > Hi, Gunter, > > On Thu, Jun 23, 2016 at 10:59 AM, Hick Gunter <h...@scigames.at> wrote: >> Open the editor application, type in your command, save to file and the view >> with a hex editor. I suspect it will be in ISO encoding. > > According to https://sqlite.org/src4/doc/trunk/www/data_encoding.wiki, > all this data should be in some kind of > UTF encoding (UTF-8 or UTF16). > And I didn't explicitly changed the encoding at all. > > Thank you. > >> >> -----Ursprüngliche Nachricht----- >> Von: sqlite-users-boun...@mailinglists.sqlite.org >> [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von >> Igor Korot >> Gesendet: Donnerstag, 23. Juni 2016 16:39 >> An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> >> Betreff: Re: [sqlite] Conversion failure >> >> Hi, Clemens, >> >> On Thu, Jun 23, 2016 at 10:33 AM, Clemens Ladisch <clem...@ladisch.de> wrote: >>> Igor Korot wrote: >>>> I am trying to find out why the following code fails to do proper >>>> conversion. >>>> It works if the tableName have "abcd", but fails if it has "abcß" >>>> (the German letter for the "ss" (looks like Greek letter beta)). >>>> >>>> const unsigned char *tableName = sqlite3_column_text( stmt, 0 ); >>>> pimpl->m_tables[m_catalog].push_back( Table( myconv.from_bytes( >>>> pimpl->(const char *) tableName ), fields, foreign_keys ) ); >>> >>> What are the byte values in tableName? >> >> I have no idea. >> I just did ALT+225 in the SQLite shell during the CREATE TABLE command. >> >> Thank you. >> >>> >>> >>> Regards, >>> Clemens >>> _______________________________________________ >>> 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 >> >> >> ___________________________________________ >> Gunter Hick >> Software Engineer >> Scientific Games International GmbH >> FN 157284 a, HG Wien >> Klitschgasse 2-4, A-1130 Vienna, Austria >> Tel: +43 1 80100 0 >> E-Mail: h...@scigames.at >> >> This communication (including any attachments) is intended for the use of >> the intended recipient(s) only and may contain information that is >> confidential, privileged or legally protected. Any unauthorized use or >> dissemination of this communication is strictly prohibited. If you have >> received this communication in error, please immediately notify the sender >> by return e-mail message and delete all copies of the original >> communication. Thank you for your cooperation. >> >> >> _______________________________________________ >> 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 > > > ___________________________________________ > Gunter Hick > Software Engineer > Scientific Games International GmbH > FN 157284 a, HG Wien > Klitschgasse 2-4, A-1130 Vienna, Austria > Tel: +43 1 80100 0 > E-Mail: h...@scigames.at > > This communication (including any attachments) is intended for the use of the > intended recipient(s) only and may contain information that is confidential, > privileged or legally protected. Any unauthorized use or dissemination of > this communication is strictly prohibited. If you have received this > communication in error, please immediately notify the sender by return e-mail > message and delete all copies of the original communication. Thank you for > your cooperation. > > > _______________________________________________ > 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
