BUG #5493: Character Encoding is not happenning properly - Mailing list pgsql-bugs

From Bakkiya
Subject BUG #5493: Character Encoding is not happenning properly
Date
Msg-id 201006080502.o5852SD8047536@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5493: Character Encoding is not happenning properly  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      5493
Logged by:          Bakkiya
Email address:      bakkiya@gmail.com
PostgreSQL version: 8.3.8
Operating system:   Suse Linux 10
Description:        Character Encoding is not happenning properly
Details:

Hi,
We have postgresql 8.3.8 version on 32 bit and 64 bit SLES servers. On both
the servers we are having the client encoding as UNICODE
show CLIENT_ENCODING --- "unicode"
We have created the database with UTF8 encoding.
But when we give uppoer/lower of any extended characters, it is behaving
differently.
Example:
32 Bit m/c:
select upper('ê') -- "Ê"
64 Bit m/c:
select upper('ê') -- "ê"

Don't think it as an issue with OS. Can you plese help us in solving this.

Thanks.

pgsql-bugs by date:

Previous
From: Florian Weimer
Date:
Subject: Re: [HACKERS] Invalid YAML output from EXPLAIN
Next
From: "Ovidiu Tanasiciuc"
Date:
Subject: BUG #5494: pg_dump dependiences sequence problem