[sqlite] Possible error using length on UTF-8 characters

[Richard Hipp]

On 2/17/16, Glyn Jones <glynj at bsquare.com> wrote:
> sqlite> select hex(id) from operators;
> C382C2ACC382C2ACC382C2AC
>
> This should show three characters of values "C2AC", and when I read from the
> DB and display on an HTML page I do see " ???"
>

No.  I think you are confused about how UTF8 works.

The hexadecimal shown above is a 6-character string as follows:

     "\u00c2\u00ac\u00c2\u00ac\u00c2\u00ac"

You are wanting this three-character string:

     "\uc2ac\uc283\uc283"

The hex encoding of the string you want would be:

     "EC8AACEC8AACEC8AAC"

-- 
D. Richard Hipp
drh at sqlite.org