Re: 7.3.2 incorrectly counts characters for unicode varchar field

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Matthew Cooper" <matty(at)cloverworxs(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 7.3.2 incorrectly counts characters for unicode varchar field
Date: 2003-09-15 15:10:19
Message-ID: 10503.1063638619@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Matthew Cooper" <matty(at)cloverworxs(dot)com> 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Matthew Cooper 2003-09-15 17:27:01 Re: 7.3.2 incorrectly counts characters for unicode varchar field
Previous Message Matthew Cooper 2003-09-15 14:50:49 Re: 7.3.2 incorrectly counts characters for unicode varchar field