Non ascii characters problems DXE7 / DbExpress 4.5.8
Posted: Mon 23 Mar 2015 16:30
Hi,
We are migrating our source code from Delphi XE2 to Delphi XE7.
We used dbExpress for Ib version 4.5.8.
When accessing database with "Default character set" set to UTF8, we have problems when string contains non ascii characters (Fields are Varchar(xx) type).
Exemple "é" appears "é"
We initialize the TSQLSconnection like :
For information, we done the same initilisation in Delphi XE2.
We tried to add this parameters :
But it there is same problem.
Can you help us ?
Regards,
We are migrating our source code from Delphi XE2 to Delphi XE7.
We used dbExpress for Ib version 4.5.8.
When accessing database with "Default character set" set to UTF8, we have problems when string contains non ascii characters (Fields are Varchar(xx) type).
Exemple "é" appears "é"
We initialize the TSQLSconnection like :
Code: Select all
ACnx.DriverName := {!4}'DevartInterBase';
ACnx.GetDriverFunc := {!4}'getSQLDriverInterBase';
ACnx.LibraryName := {!4}'dbexpida40.dll';
ACnx.VendorLib := {!4}'fbclient.dll';
ACnx.Params.Clear;
ACnx.Params.Values[{!4}'User_Name'] := Username;
ACnx.Params.Values[{!4}'Password'] := Password;
ACnx.Params.Values[{!4}'Database'] := Server + {!4}'/' + IntToStr(Port) + {!4}':' + BddFilename;
We tried to add this parameters :
Code: Select all
ACnx.Params.Values['UseUnicode'] := 'False';
ACnx.Params.Values['Charset'] := 'UTF8';
Can you help us ?
Regards,