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
