Grid is has problem with filtering Turkish "Ş" character.

[Blazor]

Hi Great Support,

I had some filterin problem on grid. i am sure its related with character "Ş"

Here is results;
First i am filtering just "Dİ"

Then im filterin "DİŞ"


So i think there is a problem about "Ş"

Thanks.

[Maran Baskar]

Hi Blazor, 

We have validated your query and understood that you have faced problem while filtering the Turkish word. We have checked the problem at our end and we could not reproduce the problem. Here, we have prepared a sample for your reference.   

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/turkish_filter1404919617  

If you are still facing the problem, then could you please share the below details.  

• Share your Syncfusion component code.
• If possible, reproduce the issue in our given sample.

 

Regards, 

Maran Baskar 

[Blazor]

Hi Maran thanks,

I checked my problem again,

It was probably because of my database(postgresql) keeps these "Ş" character in different code

Here is the generated odata query when i am typing "DİŞ" to filter;
(startswith(tolower(Kod),'d%C4%B0%C5%9E'))

When i am typeing "Dİ"
(startswith(tolower(Kod),'d%C4%B0')

When i am typeing "Dİş"

Its working again;
(startswith(tolower(Ad),'d%C4%B0%C5%9F')

So i have problem with
 %C5%9E  =  "Ş" character on database side i guess

[Vignesh Natarajan]

Hi Blazor,  

 

Query: “It was probably because of my database(postgresql) keeps these "Ş" character in different code” 

 

From your query we understand that issue occur due to your database. We have ensured the issue at our end by preparing a sample data with OdataV4 adaptor and “DİŞ” value. We are able to filer the records properly at our end without any error.  

 

If you still have queries, kindly get back to us with more details like (ActionFailure event arguments). It will be very helpful for us to validate the reported query at our end.  

 

Regards, 

Vignesh Natarajan