Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-general

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,


pgsql-general by date

Next:From: MaRCeLO PeReiRADate: 2004-01-29 11:31:49
Subject: Re: 7.3.4 freezing
Previous:From: Frank MillmanDate: 2004-01-29 09:08:58
Subject: Problem with function

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group