Field with empty space for char data type while binding Dataset

Question

Field with empty space for char data type while binding Dataset

tramesh2009 opened this issue 3 years ago · 1 comments

tramesh2009 commented 3 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

Answer 1 · 2022-08-08T03:00:29.000Z

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.