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

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for MySQL in Delphi and C++Builder
Post Reply
leposava
Posts: 1
Joined: Fri 06 Aug 2021 06:23

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

Post by leposava » 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

ViktorV
Devart Team
Posts: 3093
Joined: Wed 30 Jul 2014 07:16

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

Post by ViktorV » 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

Post Reply