By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE testaccent (name nvarchar(50));
INSERT INTO testaccent (name) VALUES ('Millière') , ('Milliere');
2 rows affected
SELECT * FROM testaccent WHERE name = 'Milliere';
| name |
|---|
| Milliere |
SELECT * FROM testaccent WHERE name='Milliere' COLLATE Latin1_General_CI_AS
| name |
|---|
| Milliere |
SELECT * FROM testaccent WHERE name='Milliere' COLLATE Latin1_General_CI_AI
| name |
|---|
| Millière |
| Milliere |