Hello,
I'm new to Appian.
I have a textfield() which works like a search engine with two buttons (clear filter and search), it works fine but if I wrote any string without special characters, it doesn't return the proper result.
Example:
User types "Olá" (which is "Hello" in Portuguese language) in the textfield(), click search, it returns the proper result because in SQL database, it contains the exact same string.
However, if user types "Ola" without ` ~ ^ ´ é á, etc. It won't return anything (false in this case)
Is there a way to solve this?
Discussion posts and replies are publicly visible
I think this is something you might need to handle at the database level. I you navigate to https://myAppianSite.com/database you can see all of your tables and different settings. For your tables you might need to update the collation on specific columns to utf8_bin or another encoding so that the database will search for accent characters as well. There should be helpful material online if you search for 'mysql query accent characters'
Thank you very much, I will surely look into it!