How to make DBX driver form MySql to trim trailing spaces in XE2

[leposava]

When I upgrade to 7.2 I got trailing spaces in the varchar fields I need spaces to be removed. I tried with CRSQLConnection but it doesnt work for delphi XE2.
I wanted to use coTrimFixedChar but DriverOptions doesnt work for XE2

Please tell me how to do it in delphi XE2

[ViktorV]

Hi Leposava,

Thanks for your request.

In order to resolve your issue can you kindly try setting TrimFIxedChar option to True and let us know the result.
Please use the code below:

Code: Select all

  CRSQLConnection.Params.Add('TrimFixedChar=True'); 

Feel free to reply to this email in case you have any additional questions or need any kind of additional instructions.

Best regards,
Viktor