Search in database for exact match containing emojis

Need help Database
1

Hi there,

I’m struggling with an strange behavior of Bubble search in database.

If you search for a text containing emojis in database such as:
“Hi :point_right:
You won’t find me”

the API will not always find the matching element even if it exists. It will work if you remove the emoji in your search and in the database

Any idea what could cause this behaviour ?

2

I simple google search found this regex string. It should help you. If you don’t know how to use regex, you can find lots of into on the forum.

(\u00a9|\u00ae|[\u2000-\u3300]|\ud83c[\ud000-\udfff]|\ud83d[\ud000-\udfff]|\ud83e[\ud000-\udfff])