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

Re: BUG #4257: about unicode extend

From: ArLi <program(at)163(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4257: about unicode extend
Date: 2008-06-21 22:08:33
Message-ID: 485D7BE1.40708@163.com (view raw or flat)
Thread:
Lists: pgsql-bugs
very sorry, is i wrong..

the version is 8.0.15.

i just copyed from wrong of server-terminal window.. -_-!

thank you for help.

arli

Michael Fuhr wrote:
> On Sat, Jun 21, 2008 at 01:25:15PM +0000, arli weng wrote:
>   
>> PostgreSQL version: 8.3
>>     
>
> What does "SELECT version()" return?  I'm wondering if the server
> isn't 8.3 but rather an earlier version (see below).
>
>   
>> 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
>>     
>
> Your INSERT statement works for me in 8.3.3, 8.2.9, and 8.1.13.
> According to the release notes version 8.1 changed UNICODE to UTF8
> and added support for 4-byte characters, so the fact that the error
> says "UNICODE" and your database doesn't appear to support 4-byte
> characters makes me wonder if you're running 8.0 or earlier.
>
>   



In response to

pgsql-bugs by date

Next:From: Bill ThoenDate: 2008-06-22 16:03:40
Subject: Abnormal termination of PostgreSQL
Previous:From: Bruce MomjianDate: 2008-06-21 20:31:09
Subject: Re: BUG #4024: xpath() results lose namespace mappings

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