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
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
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:
Feel free to reply to this email in case you have any additional questions or need any kind of additional instructions.
Best regards,
Viktor
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');
Best regards,
Viktor