Skip site navigation (1) Skip section navigation (2)

BUG #4257: about unicode extend

From: "arli weng" <program(at)163(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4257: about unicode extend
Date: 2008-06-21 13:25:15
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4257
Logged by:          arli weng
Email address:      program(at)163(dot)com
PostgreSQL version: 8.3
Operating system:   gentoo linux
Description:        about unicode extend

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

Next:From: ArLiDate: 2008-06-21 13:26:54
Subject: bug
Previous:From: Ati RosseletDate: 2008-06-20 16:38:46
Subject: BUG #4255: could not write to log file: Bad file descriptor

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group