Dear all,
I try using Aurelious & XData to migrate an application to Interbase 2020 and I have a problem with varchar and nvarchar columns charset.
I create the Interbase database manually with default character set UTF8 (I need to store Greek characters) and after that I am using the TDatabaseManager.BuildDatabase in order to create the tables.
My problem is that all varchar and nvarchar columns have as character set the ISO8859_1.
For Intebase connection I use FireDac with the following options :
...
FDConnection.DriverName := 'IB';
FDConnection.Params.BeginUpdate;
FDConnection.Params.Clear;
FDConnection.Params.add('DriverID=IB');
FDConnection.Params.add('Database=.......');
FDConnection.Params.add('User_Name=......');
FDConnection.Params.add('Password=.....');
FDConnection.Params.add('CharacterSet=UTF8');
FDConnection.Params.add('ExtendedMetadata=False');
FDConnection.Params.add('Protocol=Local');
FDConnection.Params.add('RoleName=Admin');
FDConnection.Params.add('OpenMode=Open');
FDConnection.Params.EndUpdate;
FDConnection.TxOptions.AutoCommit := True;
...
Can you guide me plase on how I can declare the correct character set ?
Thank you in advance.