Thread: BUG #5493: Character Encoding is not happenning properly

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.

"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