On 2/17/16, Richard Hipp <drh at sqlite.org> wrote:
> 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"
Upon re-reading, I see that you really want this string:
"\u00ac\u00ac\u00ac"
The UTF-8 encoding there is:
"C2ACC2ACC2AC"
There way, this is not what you have stored in your table.
>
> The hex encoding of the string you want would be:
>
> "EC8AACEC8AACEC8AAC"
>
> --
> D. Richard Hipp
> drh at sqlite.org
>
--
D. Richard Hipp
drh at sqlite.org
