select query truncates values from CHAR columns

select query truncates values from CHAR columns

Postby 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.
azemerov
 
Posts: 2
Joined: Thu 04 Nov 2010 13:30

Postby 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.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Postby 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? :)
azemerov
 
Posts: 2
Joined: Thu 04 Nov 2010 13:30

Postby 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.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle