Search Accounts With Special Characters

(0) Share

Report

Posted on by Community Member

Hi,

I wonder if it is possible to search with special characters on accounts list. For example an account named 'CARSI', users want to find this account when they write 'ÇARŞI' to search bar.

Thanks.

*This post is locked for comments

All responses (3)

Answers (0)

ashlega 34,477 on at

Like (1)

Report

RE: Search Accounts With Special Characters

Understand that, but you'll probably have to to change database collation:

stackoverflow.com/.../sql-search-on-fields-containing-diacritics

Looks like you'll need Accent-insensitive collation

Or you might also try enabling the full text search - have a look at the Diacritics setting there:

docs.microsoft.com/.../configure-and-manage-thesaurus-files-for-full-text-search
Community Member on at

Like (0)

Report

RE: Search Accounts With Special Characters

Thanks for the answer but they don't want to use the wild card, they expect special characters pretent like English characters.

I think this is not possible.
ashlega 34,477 on at

Like (0)

Report

RE: Search Accounts With Special Characters

Hi,

Dynamics will search for the accounts based on the keyword match - it won't be replacing any characters in that keyword.

Your users might try using wildcard character:

*AR*I

That would give them both CARSI and ÇARŞI accounts.