problems with char 247

From: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
To: "postgres" <pgsql-general(at)postgresql(dot)org>
Subject: problems with char 247
Date: 2002-09-27 10:00:38
Message-ID: 006601c2660c$bb6515c0$aa0f5ac2@canaan.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All

My db is in hebrew and i have problems to select using regex where the word
end with ascii char 247.

This work, but it dont distinguis between whole word and partial:
SELECT l_name from links where l_name ilike '%צדק%';

This dont work, return nothing.
SELECT l_name from links where l_name ~* '[[:<:]](צדק)[[:>:]]';

If i drop the 'ק' ( char 247 ) i get the list as i suppose to be with the
'ק'.
SELECT l_name from links where l_name ~* '[[:<:]](צד)[[:>:]]';

This are the chars searched for:
צ - 246
ד - 227
ק - 247

Any idea ?

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-09-27 10:03:19 Re: query speed depends on lifetime of frozen db?
Previous Message Penang 2002-09-27 09:51:08 Feature comparison between Postgresql, Oracle and Mysql ?