How to find names with special characters like "Jose" on MS SQL-Server

Question

If I search for "José", the result is 0. If I search for "Josè", and "Jôse" will also fail.

select name from TblName where name = 'Jose' or name = 'Josè' or name = 'Jôse'

I know a replacement ?: where name like 'Jos?' or name like 'J?se'But it is very uncontrollable and who knows if there is any special form of 's'?

I want to find "Jose" and get all variants of it with all possible special characters on all single characters; how to do it?

Answer 1

See How to perform a comparison without accent (e with è, é, ê, and ë) in SQL Server?

Using the custom mapping of your choice:

SELECT * 
FROM Venue 
WHERE Name COLLATE SQL_Latin1_General_CP1_CI_AI Like '%cafe%' 

CI " " AI "Accent Insensitive".

, : Remplacer les accents dans une chaîne.

Answer 2

. , , Amazon , 30 .

3