Field with empty space for char data type while binding Dataset

Embarcadero / IB.NETDataProvider

InterBase database .NET Data Provider

Other

12 stars 7 forks source link

Field with empty space for char data type while binding Dataset #12

Closed tramesh2009 closed 2 years ago

tramesh2009 commented 2 years ago

Hi,

I got empty space for char data type field while binding Dataset

How to trim the space for char data type fields while fetching record?

Thank You

jeffovercash commented 2 years ago

In the last release, I added a connection string property and a IBDatabase property called TruncateChar. By default it is false, but when set true will right trim all char datatypes. VarChar's are not trimmed.

truncate_char is for the connectionstring level, TruncateChar is the IBDatabase property. At this time it only has that level of granularity because the person requesting it was fine with everything at the IBDatabase level behaving the same.