Re: [HACKERS] [PATCHES] character type value is not padded with spaces

I think you need to test with 5 characters, not 3. -- Tatsuo Ishii > Ahemm,... > > UNICODE DB: > > create table t (a char(10)); > set client_encoding = iso88591; > insert into t VALUES ('æøå'); > > select a, octet_length(a),length(a) from t; > a | octet_length | length > +

Re: [HACKERS] [PATCHES] character type value is not padded with spaces

Ahhh... > -Original Message- > From: Tatsuo Ishii [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 24, 2005 9:26 AM > To: John Hansen > Cc: [EMAIL PROTECTED]; pgsql-patches@postgresql.org; > pgsql-hackers@postgresql.org > Subject: Re: [PATCHES] character type value is not padded with spac

Re: [HACKERS] [PATCHES] character type value is not padded with spaces

Ahemm,... UNICODE DB: create table t (a char(10)); set client_encoding = iso88591; insert into t VALUES ('æøå'); select a, octet_length(a),length(a) from t; a | octet_length | length +--+ æøå| 13 | 3 (1 row) This is with 8.0.2.

Re: [HACKERS] [PATCHES] character type value is not padded with spaces

Hackers, The problem he found is not only existing in Japanese characters but also in any multibyte encodings including UTF-8. For me the patch looks good and I will commit it to 7.3, 7.4, 8.0 stables and current if there's no objection. -- Tatsuo Ishii > Character type value including multibyte