Filter Turkish Character Problem

Hi all,


i am new to this issue. I download to demo version and use AutoComplete control. All of the my database records are uppercased. When i search lowercase "i" character, give me the text "there were no results". When i search uppercase "İ" character , results are returned. My control is as below. What can i do ?

<ej:Autocomplete ID="auFirmaSektor"      Width="100%" Height="40" ShowRoundedCorner="true" DataSourceID="sqlFirmaSektorleri" runat="server" MinCharacter="3" PopupWidth="300px" Font-Size="8" ShowResetIcon="True" FilterType="Contains" CaseSensitiveSearch="false" ShowPopupButton="True" ShowLoadingIcon="true" ShowEmptyResultText="true" WatermarkText="Firma Sekötürünü Seçiniz" PopupHeight="400px"> <MultiColumnSettings Enable="True" ShowHeader="True"> <Columns>      <ej:Columns HeaderTextAlign="Left" TextAlign="Left" Field="CODE" HeaderText="Sektör Kodu" />
<ej:Columns HeaderTextAlign="Left" TextAlign="Left" Field="DESCRIPTION" HeaderText="Sektör Adı" /> </Columns>      </MultiColumnSettings> </ej:Autocomplete>

5 Replies

AP Arun Palaniyandi Syncfusion Team May 11, 2018 12:40 PM UTC

Hi Ali Osman,  
  
Thanks for contacting Syncfusion support.  

We have tried to replicate your reported issue based on the shared details and code snippets but we could not replicate the issue.  Autocomplete will return the data based on the typed character and it is not case sensitive by default. Only when we enable the CaseSensitiveSearch, it will be case sensitive.  In the shared code you didn’t enable the case sensitive search CaseSensitiveSearch="false" , so this have not caused the issue.
 
 
You have also set the MinCharacter property as 3, and this property used to show the result after the number of characters typed. So we suspect that this may cause this issue and suggest you to check it. 
 
We have also prepared sample using SQL datasource and please it below for your reference. 
 
Please check our shared sample and if you still face any issue means, please let us know the below details. 
 
  • Open your console window and check for any console errors and share the issue screenshot or video, if any?
  • If possible, please use our sample to reproducible your issue to validate from our side?
  • Share us your uppercased database records if possible? Because we suspect that the Turkish language may cause this problem.
 
Let us know if you have any further queries.   
  
Regards,  
Arun P.  



AO Ali Osman May 13, 2018 07:11 PM UTC

Hi,

Firstly thank you for your reply.

I send you a image about the error. I want to found "DİYARBAKIR" in the auto complete box. When i write "di" letters, in the result there is no correct answers. i think when i write "i" letters, the control accept it " I " letters. that is the problem.


AP Arun Palaniyandi Syncfusion Team May 14, 2018 01:15 PM UTC

Hi Ali Osman,  
  
Thanks for your udpate.  
 
Query1:” I send you a image about the error.” 
 
Actually we didn’t get an image about the error that you attached. So could you please attach your image once again. 
 
Query 2:” I want to found "DIYARBAKIR" in the auto complete box. When i write "di" letters, in the result there is no correct answers. i think when i write "i" letters, the control accept it " I " letters. that is the problem.” 
 
We once again tried to replicate your reported issue by your given letter but  till we were unable to replicate this issue. We have typed letter as “di” but the result “DIYARBAKIR” gets displayed.  
 
We have also recorded a video for your reference and please find it below. 
 
Please check our previous shared sample and the current shared video and if you still face any issue means, share the console error that we asked. Also If possible, share your  issue sample to validate from our side. 
 
Let us know if you have any further queries.   
  
Regards,  
Arun P.  



AO Ali Osman May 14, 2018 01:19 PM UTC

im at work now and ican not send image again. But when i watch the video you sent, you wrote the database "DiYARBAKIR". The second letter is lowercase i think. Please write it "DİYARBAKIR"  and repeat again.


AP Arun Palaniyandi Syncfusion Team May 16, 2018 06:03 AM UTC

Hi Ali Osman, 
 
Thanks for your update. 
 
We have now changed our keyboard settings to Turkish and tried to replicate this issue. Hence we can now able to replicate this issue and on further validation found that this issue because our Autocomplete doesn’t support Accent letters. Yes, currently we don’t have support for filtering diacritics characters in our EJ Datamanger. Hence we have considered this as a feature and this will be included in any of our upcoming releases.  
 
But this support is given in our EJ2 Autocomplete and hence we suggest you to try out this.    
   
 
 
UG reference link:  
 
 
Let us know if you need any further assistance.   
      
Regards,
Arun P.
 


Loader.
Up arrow icon