BUG #5493: Character Encoding is not happenning properly

Started by Bakkiyaalmost 16 years ago2 messagesbugs
Jump to latest
#1Bakkiya
bakkiya@gmail.com

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.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Bakkiya (#1)
Re: BUG #5493: Character Encoding is not happenning properly

"Bakkiya" <bakkiya@gmail.com> writes:

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.

Sounds like you have different locale settings in the two databases.

regards, tom lane