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.
select query truncates values from CHAR columns
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.