Skip to main content
armandov0001
armandov0001
March 12, 2021
Question

Smart Search

  • March 12, 2021
  • 2 replies
  • 0 views

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?

    2 replies

    danny.verb
    danny.verb
    March 12, 2021

    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'

      armandov0001
      armandov0001Author
      March 12, 2021

      Thank you very much, I will surely look into it!

      Terms & ConditionsAccessibility statement