| 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: | Whole Thread | Raw Message | 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 ? |