RADFILTER : Filter RadGrid where the column contains accent.

[Fernando]

I have a RadFilter and select the function "equals" and the text "Peru" and when I press the Apply button, no results found. But radgrid column exists in the text column country "Perú" with accent, I tried putting the property: <GroupingSettings CaseSensitive = "false"> </ GroupingSettings>, but only ignores case sensitive, I need to omit the accents.
Attached image.

Please any advice?

 PDT:

In basic search I succeeded with SP where the condition COLLATE establish Latin1_General_CI_AI, I need to achieve the same result with RadFilter.
Attached image: Search Search basic.png and basic sp.png​

Thanks.

[Fernando]

Sorry, I was wrong image, this type of search does not omit accents.

[Eyup]

Hello Fernando,

I've already replied in the following forum thread about that matter:
http://www.telerik.com/forums/filtering-case-insensitive

Regards,
Eyup
Telerik

[Isabel]

Hi, Fernando.

   I know this post is one year old. But no I'm having the same problem.

Did you find the way to fix the issue?. Is there any filter property to search with accent insensitive??.

[Jesús]

Hi.

I have the same problem.

<GroupingSettings CaseSensitive="false" /> only apply with case and lower letters, but not with accent letters.

[Isabel]

Hi, Jesús.

At the end I used the solution posted in http://www.telerik.com/forums/accent-insensitive-filtering-filtering-on-a-different-column

Regards,

Isabel.