I’m trying to Search or FullText Search a database, the problem is that if the user omits an accent in the word he/she types in (The user’s input is the key search string) the search result is empty … if the accent is correctly typed in, the results are valid.Is there any way to render Searhing or FullText searching accent insensitive?
Subject: Searching with accents (french in this case)
FT Searching does an accent insensitive search, but not Search … it is Case and accent sensitive.