ClientDataset Filter (Non English Word)

[Henry Olive 5]

Good Day,

 

Delphi 10.3

I have problem when filtering a table with non english words

 

Button1.Click Event

var

SearchText :=String;

begin

  SearchText :=Edit1.Text (Which is  'MİSA' )

  CDS1.FilterOptions := [foCaseInsensitive];

  CDS1.Filtered := False;

  CDS1.Filter := UPPER ( CATEGORY ) LIKE ' + QuotedStr (SearchText + '%');

  CDS1.Filtered := True;

end;

Eventhough i have MİSA in the table's Category field, I get an empty result

What am i doing wrong ?

 

P.s : When i use ( In FB 3 Sql )  SELECT FROM MYTABLE WHERE UPPER(CATEGORY) LIKE 'MİSA%'

I get expected results w/o any problem

 

Thank You