Re: [GENERAL] How to convert Big5 to UTF8

2006-01-20 Thread Martijn van Oosterhout
On Fri, Jan 20, 2006 at 09:56:40AM +0800, Alex CS Huang wrote: > 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 va

[GENERAL] How to convert Big5 to UTF8

2006-01-19 Thread Alex CS Huang
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: