Accent Insensitive Select in DataTable

[darXstar]

hi, I've this problem : we work with a sql database which operates in accent-insensitive mode, once I've cached some data from it to my .NET application, how can I search within this data (contained in a DataTable) with an accent-insensitive query? I mean I'd like to obtain the same result (i.e.) " André " in any case if user is searching for: DataTable.Select("name LIKE 'andré') DataTable.Select("name LIKE 'andrè') DataTable.Select("name LIKE 'andre') thanks to anyone may answer Darx

[Mark J Miller]

Not sure which CultureInfo to use but I'd recommend setting the Locale propery of the DataTable. Try Invariant culture setting - it should ignore accents.

[darXstar]

thanks for your reply, I've tried but with no success. It seems there is no way to directly perform an accent insensitive research with Select() function in a DataTable as like as in sql environment. could somebody suggest a workaround?