Incorrect Results From Select When Using Non-English Characters

From: mirela <mirela(at)modelity(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Incorrect Results From Select When Using Non-English Characters
Date: 2004-01-29 10:38:22
Message-ID: 4018E29E.5020705@modelity.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm using RedHat 9 and PostgreSQL 7.3.4.
I have a table with a column of type varchar and length 250. This column
includes both English and Hebrew text values.

The following select statements work fine:
select * from table where column='English value';
select * from table where column like 'Hebrew value';

However, the following select retrieves all Hebrew values with the same
number of characters:
select * from table where column='Hebrew value';

Using the same PostgreSQL version under RedHat 7.3 works just fine.

Any help would be appreciated,
Mirela.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message MaRCeLO PeReiRA 2004-01-29 11:31:49 Re: 7.3.4 freezing
Previous Message Frank Millman 2004-01-29 09:08:58 Problem with function