This is a migrated thread and some comments may be shown as answers.

Grid With EDS can't filter unicode

3 Answers 162 Views
Grid
This is a migrated thread and some comments may be shown as answers.
giorgi
Top achievements
Rank 1
giorgi asked on 14 Feb 2012, 01:30 PM
Hello. I have RadGrid with EntityDataSource. When I filter grid by column where expression is generated like :
where it.someValue = 'unicode text'
but it should be like
where it.someValue = N'unicode text'
Is there a way to make it work?
thanks in advance

3 Answers, 1 is accepted

Sort by
0
Marin
Telerik team
answered on 17 Feb 2012, 09:53 AM
Hi,

 If you need to modify the filter expressions prior to filtering you can do this in the in the ItemCommand event as shown in this help topic

Greetings,
Marin
the Telerik team
Sharpen your .NET Ninja skills! Attend Q1 webinar week and get a chance to win a license! Book your seat now >>
0
giorgi
Top achievements
Rank 1
answered on 24 Feb 2012, 11:57 AM
Is there any simple way for grid to know that specific column is in unicode so that where text would be
"([CustomerID] LIKE N'%ALFKI%')"; 
instead of 
"([CustomerID] LIKE '%ALFKI%')";  

0
Marin
Telerik team
answered on 24 Feb 2012, 06:38 PM
Hi,

 The grid does not automatically generate the filter expression based on the unicode type of the column. That's why you can modify it in the ItemCommand event and simple add the additional (N) to the filter expression as I specified in the my previous post.

All the best,
Marin
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Tags
Grid
Asked by
giorgi
Top achievements
Rank 1
Answers by
Marin
Telerik team
giorgi
Top achievements
Rank 1
Share this question
or