ClientDataset.Filter ( Non English Character )

[Henry Olive 5]

 

I moved this topic from Object Pascal to here which is correct forum

 

Good Day,

 

Delphi 10.3

I have problem when filtering a table with non english character

 

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

[Dmitry Arefiev 101]

IMO, this was fixed after 10.3. So, upgrade ...

[Henry Olive 5]

Thank You Dmitry

[aehimself 396]

If you don't have a chance to upgrade, you can take a look at Zeos. It handles Unicode filters and should be able to connect to your preferred RDBMS.