1

I'm trying to find html entities (e.g. ü) within a varchar field:

set define off;
SELECT description FROM descriptions WHERE contains(description, 'ü') > 0;
SELECT description FROM descriptions WHERE contains(description, '&uuml') > 0;
SELECT description FROM descriptions WHERE contains(description, '%uuml%') > 0;

set define off;
set escape on;
SELECT description FROM descriptions WHERE contains(description, '\ü') > 0;
SELECT description FROM descriptions WHERE contains(description, '\&uuml') > 0;
SELECT description FROM descriptions WHERE contains(description, '\&uuml\;') > 0;

Not a single query is working, although there are plenty of potential results. Any ideas? Many thanks!

Improve this question

1 Answer 1

Reset to default
1

Did you define an Oracle Text index on description? If so, how did you define that index? Did you resynchronize the index after loading the data?

If you use INSTR rather than CONTAINS, do you get results?

SELECT description 
  FROM descriptions 
 WHERE instr(description, 'ü') > 0;
Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Hey Justin, "instr" made my day :) Thanks a lot!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.