Tatsuo Ishii wrote:
>
> If you regard the unicode code point as simply a number, why not
> regard the multibyte characters as a number too? I mean, since 0xC2A9
> = 49833, "select chr(49833)" should work fine no?
>
>
No. The number corresponding to a given byte pattern depends on the
endianness of the architecture. That's exactly why we can't sanely use
the byte pattern of the encoded characters as numbers.
cheers
andrew