Postgres Pro
Downloads
Home   >   mailing lists

BUG #4257: about unicode extend - Mailing list pgsql-bugs

From arli weng
Subject BUG #4257: about unicode extend
Date
Msg-id 200806211325.m5LDPFN0060573@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4257: about unicode extend  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: BUG #4257: about unicode extend  (Michael Fuhr <mike@fuhr.org>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: ArLi
Date:
Subject: bug
Next
From: Tom Lane
Date:
Subject: Re: BUG #4257: about unicode extend