Re: [BUGS] 7.3.2 incorrectly counts characters for unicode varchar field

[Tom Lane]

"Matthew Cooper" <[EMAIL PROTECTED]> writes:
> Attached is the UTF-8 encoded sql file in case it got messed up in the mail
> transfer.

Ah, no doubt it did.

This works fine for me, using either 7.3.4 or CVS tip.  Are you sure
that the system knows your client-side encoding is supposed to be UTF8?

uc=# show client_encoding ;
 client_encoding
-----------------
 UNICODE
(1 row)

uc=# create table mgc(f1 varchar(10));
CREATE TABLE
uc=# \i mgc.sql
INSERT 328444 1
uc=# select * from mgc;
          f1
----------------------
 ͈†Õ’ŸÓ£ƒð¿ Íˆ†Õ’ŸÓ£ƒð¿ Ó£ƒð¿ 
(1 row)

uc=# select length(f1) from mgc;
 length
--------
     10
(1 row)


                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org