The following bug has been logged online:
Bug reference: 4257
Logged by: arli weng
Email address: program@163.com
PostgreSQL version: 8.3
Operating system: gentoo linux
Description: about unicode extend
Details:
the command (chinese by utf-8):
INSERT INTO "title" VALUES(46307243,46307898,'é
é¼ ðª¨');
in sqlite text type, no problem..
in postgres report error:
invalid byte sequence for encoding "UNICODE": 0xf0
the 𪨠char is unicode extend b,
by utf-8 format, the hex code is "f0 aa 95 a8", because unicode extend b,
must start by 0xf0
but postgres cannot support it?
server/database/client encoding has unicode already.
help me pls, because i love postgres..
and sorry my english
