راهول
I have a table like this in mysql. Need to retrieve englishName by passing arabicName through query entity. While passing the arabicName through rule input in query filter the expression is returning no matching data found. I have also tried Query Database smart service through process model but was of no success.
NB: For knowledge ,collation and charset for my table and column is set to charset= utf-8 and collation= utf-8_general_ci.
If anyone have faced the same issue and know how to solve this problem will be a great help.
Thanks.
Discussion posts and replies are publicly visible
Hi, combining this https://stackoverflow.com/questions/4322191/how-many-bytes-do-we-need-to-store-an-arabic-character and this https://mathiasbynens.be/notes/mysql-utf8mb4 should help you.
Thanks Stefan for the reference. I am able to store arabic value in database and retrieve the same in appian without any query filter. But when i am trying to retrieve it using query filter by passing arabicName it is returning no matching data found.