Detect Fields That Contain Emojis

Products

• Clarity PPM On Premise

Issue/Introduction

If needing to find out what views contain emojis, what query can be ran.

 

Resolution

For Oracle, the following example query (on the table of Clarity views) can be used:

SELECT * FROM odf_ui_views
WHERE REGEXP_LIKE(name, UNISTR('[\FFFF-\DBFF\DFFF]'))
ORDER BY created_date DESC;