Devart Forums

Posted: **Fri 06 Aug 2021 06:30**

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

Posted: **Mon 09 Aug 2021 16:29**

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

Devart Forums

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

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

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