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 ?
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 ? |