# SQLCipher Regex Support

**URL:** <https://discuss.zetetic.net/t/sqlcipher-regex-support/3134>\
**Category:** SQLCipher\
**Created:** [October 1, 2018, 8:12am UTC](https://discuss.zetetic.net/t/sqlcipher-regex-support/3134 "2018-10-01T08:12:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![chitabi](https://avatars.discourse-cdn.com/v4/letter/c/a87d85/32.png) [@chitabi](https://discuss.zetetic.net/u/chitabi)\
**Post date:** [October 1, 2018, 8:12am UTC](https://discuss.zetetic.net/t/sqlcipher-regex-support/3134/1 "2018-10-01T08:12:35Z")

</div>

Hi  
My dictionary project use arabic language for doing searchview between search list. run project was successful with using regex. but using of SQLCipher for encrypt caused error. when typed arabic character in search view:

net.sqlcipher.database.SQLiteException: no such function: REGEXP: while compiling: Select \* From tblWord Where word\_arabic REGEXP ‘^ل[ًٌٍَُِّْ]{0,}.\*’

how can i to fix this error. is there example or tutorial?  
thanks for answer.

---

<div class="post-metadata">

**Author:** ![developernotes](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.zetetic.net/developernotes/32/1309_2.png) [@developernotes](https://discuss.zetetic.net/u/developernotes)\
**Post date:** [October 1, 2018, 2:48pm UTC](https://discuss.zetetic.net/t/sqlcipher-regex-support/3134/2 "2018-10-01T14:48:44Z")

</div>

Hi @chitabi

This question has been addressed in the below link. If you have additional follow-up questions, please feel free to post those below:

> [@net.sqlcipher.database.SQLiteException: no such function: REGEXP](https://discuss.zetetic.net/t/net-sqlcipher-database-sqliteexception-no-such-function-regexp/1778/2):
>
> Hello @Bharath_Kumar_Bachin - no SQLCipher doesn’t naively support a regex function. Like the upstream SQLite, if you provide your own regexp() function the keyword should work however: The REGEXP operator is a special syntax for the regexp() user function. No regexp() user function is defined by default and so use of the REGEXP operator will normally result in an error message. If an application-defined SQL function named “regexp” is added at run-time, then the “X REGEXP Y” operator will be …