Agreed. The problem is that "length(id)" returns double the number of UTF-8 characters, rather than the actual number input to the field using "insert".
-----Original Message----- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Meinlschmidt Stefan Sent: 17 February 2016 13:57 To: sqlite-users at mailinglists.sqlite.org Subject: Re: [sqlite] Possible error using length on UTF-8 characters > sqlite> select hex(id) from operators; > C382C2ACC382C2ACC382C2AC This is hex utf8 for "??????", i.e. 3? 0xc2 0xac, which again is utf8 for "?" (0xac) S.M. -- Dipl.-Phys. (Univ) Stefan Meinlschmidt, Senior Software Engineer Am Wolfsmantel 46, 91058 Tennenlohe, Germany Tel: +49-8458-3332-531 stefan.meinlschmidt at esolutions.de Fax: +49-8458-3332-20-531 _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
