How to convert Big5 to UTF8

From: Alex CS Huang <alex(at)smoc(dot)com(dot)tw>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: How to convert Big5 to UTF8
Date: 2006-01-20 01:56:40
Message-ID: 1137722200.924.11.camel@alex
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, All,
I create a database which encoding is UTF8, and create a table test
create table test ( name varchar);
I insert a data '\244\350' encoding is Big5, I wish translate them to
UTF8, so I use
insert into test values ('convert('\244\350' using big5_to_utf_8));
I got an error:
ERROR: invalid byte sequence for encoding "UNICODE": 0xe8;

How could I do for this problem? any ideas.

Alex CS Huang

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rodrigo Gonzalez 2006-01-20 02:12:20 Re: Upgrade Problem: 7.4.3 -> 8.1.2
Previous Message Rich Shepard 2006-01-20 01:56:17 Re: Upgrade Problem: 7.4.3 -> 8.1.2