How to check character is Arabic in SQL oracle

Question

I was looking for function or way to cross check character is Arabic.

Any help will be appreciated.

I am using oracle SQL & tried below sql Query

select count(*) from dual where regexp_like('أ', '['||UNISTR('\0600')||'-'||UNISTR('\06FF')||']')

But it does not work

Answer 1

Arabic Script: https://en.wikipedia.org/wiki/Arabic_script_in_Unicode

The unicode character range for Arabic is: 0600–06FF

(0600–06FF, 256 characters)

---

Knowing the above, you would check your character to see if it's within the unicode range above, if it is, it's an Arabic character.