The following bug has been logged online:
Bug reference: 5493
Logged by: Bakkiya
Email address: bakkiya(at)gmail(dot)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.