select query truncates values from CHAR columns

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
azemerov
Posts: 2
Joined: Thu 04 Nov 2010 13:30

select query truncates values from CHAR columns

Post by azemerov » 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.

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » 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.

azemerov
Posts: 2
Joined: Thu 04 Nov 2010 13:30

Post by azemerov » 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? :)

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » 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.

Post Reply