The hex dump shows the sz-ligature encoded as (hex) e1. That is NOT a valid UTF sequence.
Sqlite ASSUMES and EXPECTS all input to be UTF encoded. Passing ISO/ANSI encoded special characters in strings is ok as long as the presentation layer on both sides EXPECTS that same encoding. Using ISO/ANSI encoded characters in SQL Statements is not supported. It is up to your front end to properly convert between encodings in the presentation layer and in the data storage layer. I have a friend who owns an automated dog hotel. To check in your dog, it needs to go inside a standard dog box which is then put on a conveyor belt. To check out your dog, you present your receipt to a scanner, which causes the box to be retrieved and presetned on the conveyor belt. The boxes are usually never opened. Some folks have successfully managed to have their cats stay there. He recently added an automated trimming service, which would open the box, scan the dog, determine if nails or coat need trimming and perform the trimming. This service crashed when a cat owner inadvertently selected this option... -----Ursprüngliche Nachricht----- Von: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Igor Korot Gesendet: Freitag, 24. Juni 2016 04:14 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] Conversion failure Simon, On Thu, Jun 23, 2016 at 8:44 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 23 Jun 2016, at 11:42pm, Igor Korot <ikoro...@gmail.com> wrote: > >> OK, so are they UTF-8, UTF-16 or something else? >> And I'm talking the default one - the one which is set when I just >> open the shell tool and say CREATE TABLE() on the empty database. >> Knowing this will help with the exception I am seeing. > > You can find out which encoding is being used by using > > PRAGMA encoding > > For further details please see > > <https://www.sqlite.org/pragma.html#pragma_encoding> SQLite version 3.9.2 2015-11-02 18:31:45 Enter ".help" for usage hints. sqlite> PRAGMA encoding; UTF-8 sqlite> SELECT name FROM sqlite_master WHERE type="table"; leagues owners positions positionsforleague scorehits scorepitch scorehitsforleague scorepitchforleague teams teamsforleague playerposition playerscorehits playerscorepitches targetshits targetspitches playerdraft playerpositioninleague players playersinleague leaguescorehitter leaguescorepitcher abcß sqlite_sequence sqlite> The code from the initial post works for all tables but "abcß". And here is the relevant piece of bytecodes: http://imgur.com/Trzylo4. Thank you. > > Simon. > _______________________________________________ > 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
