How to compare strings at C# like in SQL server case insensitive and accent insensitive

Question

Alright here 4 words which are equal at SQL server Latin1_General_100_CI_AI collation which is case insensitive and accent insensitive

taraflı
TaraFLI
TARaFLİ
Tarafli

However i could not find a way to compare these as equal at C# .net 4.5.1

Are there any way to make such comparsion like in SQL server ?

Event RemoveDiacritics method at that thread fails

@MelanciaUK no solution there try yourself please – Furkan Gözükara Jan 12 '15 at 15:54 — Furkan Gözükara, Jan 12 '15 at 15:54
@MonsterMMORPG I deleted my answer since it didn't help. – Christos Jan 12 '15 at 15:56 — Christos, Jan 12 '15 at 15:56

score 2 · Accepted Answer · answered Jan 12 '15 at 16:04

2

This compares all those strings as equal:

string.Compare(s1,s2,
               CultureInfo.InvariantCulture,
               CompareOptions.IgnoreNonSpace | CompareOptions.IgnoreCase)

answered Jan 12 '15 at 16:04

Mark Cidade

Example string.Compare("citroen","Citroën", CultureInfo.InvariantCulture, CompareOptions.IgnoreNonSpace | CompareOptions.IgnoreCase) 0 – Pažout Jan 31 '20 at 14:19

1 Answers1