Accent Insensitive DataTable.Select

[joel paula]

I have a DataTable with data in it. I use the Select method to "find"
certain rows. The problem with this method is that it performs an
Accent Sensitive filter on the data. I need Accent Insensitive:
André=Andrè=Andre.

I tried setting the DataTable Locale to CultureInvariant but it
doesn't solve my problem. I can't find any information on how to
create an Accent Insensitive CultureInfo. I also see the DataTable has
a private CompareInfo field but I can't access it.

If anyone can provide any kind of pointers to possible solutions, I
would appreciate it.

Thanks.
Joel

 

[Cor Ligthert[MVP]]

Joel,

What you want to do, a character with an accent is a distinct character from one whithout one.

It is a kind of behaviour from people who use languages from the North West coast from Europe to just ignore that and think that their 26 basic characters are the only ones.

I find it by instance always funny as I hear those people commonly pronounce the name Walensa

Cor


"joel paula" <[email protected]> schreef in bericht I have a DataTable with data in it. I use the Select method to "find"
certain rows. The problem with this method is that it performs an
Accent Sensitive filter on the data. I need Accent Insensitive:
André=Andrè=Andre.

I tried setting the DataTable Locale to CultureInvariant but it
doesn't solve my problem. I can't find any information on how to
create an Accent Insensitive CultureInfo. I also see the DataTable has
a private CompareInfo field but I can't access it.

If anyone can provide any kind of pointers to possible solutions, I
would appreciate it.

Thanks.
Joel