Attached is the UTF-8 encoded sql file in case it got messed up in the mail transfer.
And here it is pasted in directly from the window that was displaying
chinese characters.
insert into mgc values ('分钟练习分钟练习练习');
Looking at the UTF-8 documentation, 10 chinese characters could be any
number of bytes, each character being say 2 or 3 characters.
Matty.
----- Original Message -----
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Matthew Cooper" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, September 13, 2003 5:51 PM
Subject: Re: [BUGS] 7.3.2 incorrectly counts characters for unicode varchar
field
> > insert into mgc values ('Ã¥Ë?â? éâ?TŸç»Æ'ä¹ Ã¥Ë?â?
éâ?TŸç»Æ'ä¹ ç»Æ'ä¹ ');
>
> I don't think this string is correctly unicode-encoded. Anyway "length"
> claims it is 30 characters.
>
> regards, tom lane
>
mgc.sql
Description: Binary data
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
