Re: BUG #2193: INITCAP and LOWER/UPPER string conversion error - Mailing list pgsql-bugs

From Andras Got
Subject Re: BUG #2193: INITCAP and LOWER/UPPER string conversion error
Date
Msg-id 43D388FE.8030301@antiszoc.hu
Whole thread Raw
In response to Re: BUG #2193: INITCAP and LOWER/UPPER string conversion error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
I solved this, this was a local issue. I tried to cancel my letter, but noo=
ne bothered with the=20
cancelling mail. :)

Yes this was a locale mixup. Sorry.

Regards,
Andrej


Tom Lane =EDrta:

> "Andras Got" <andrej1981@gmail.com> writes:
>=20
>>I'm trying to select with LOWER/UPPER and INITCAP but they return bad val=
ues
>>after hungarian accentuated letters (e.g: =E9 =E1 =FB
>>=FA =F5 =F3 =FC).
>=20
>=20
> Are you sure you are using the right locale and database encoding?
> If so, what are they?
>=20
> There are some locale-related fixes in the latest releases (8.0.6
> and 8.1.2), though I'm not sure if they address your problem.
>=20
>             regards, tom lane
>=20

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2193: INITCAP and LOWER/UPPER string conversion error
Next
From: "Sunil Basu"
Date:
Subject: BUG #2197: PostgreSQL error- 'could not read block 0 of relation'