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.
-----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[email protected]] Im Auftrag von Igor Korot Gesendet: Donnerstag, 23. Juni 2016 17:58 An: SQLite mailing list <[email protected]> Betreff: Re: [sqlite] Conversion failure Hi, Gunter, On Thu, Jun 23, 2016 at 10:59 AM, Hick Gunter <[email protected]> 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: [email protected] > [mailto:[email protected]] Im Auftrag von > Igor Korot > Gesendet: Donnerstag, 23. Juni 2016 16:39 > An: SQLite mailing list <[email protected]> > Betreff: Re: [sqlite] Conversion failure > > Hi, Clemens, > > On Thu, Jun 23, 2016 at 10:33 AM, Clemens Ladisch <[email protected]> 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 >> [email protected] >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > 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: [email protected] > > 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] 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: [email protected] 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
