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 ?