Devart Forums

Posted: **Thu 04 Nov 2010 13:38**

Hi,
I have a table with a column defined as CHAR(36). When I select from this table, DataReader returns values with trail spaces truncated out.
Same query returns non-truncated 36-char values if I use different provider (DDTek or MS OracleClient) or run it in Sql*Plus.
Thank you.

Posted: **Fri 05 Nov 2010 10:03**

Please upgrade to the 5.70.190 version of dotConnect for Oracle and use the "Trim Fixed Char=false;" connection string parameter. This issue was discussed in this thread: http://www.devart.com/forums/viewtopic.php?t=12690.

Posted: **Fri 05 Nov 2010 13:37**

I'm using dotConnect for Oracle 6.0.10.
It doesn't accept connection string parameter "Trim Fixed Char". And more, class Devart.Data.Oracle.OracleConnection has no TrimFixedChar property at all.

May be I should downgrade the version?

Posted: **Fri 05 Nov 2010 14:11**

Yes, please install the 5.70.190 version. dotConnect for Oracle v 6.0.10 Beta doesn't include this feature.

Devart Forums

select query truncates values from CHAR columns

select query truncates values from CHAR columns