Search found 1 match

by Daniel Stucki
Mon 18 Aug 2008 11:32
Forum: dotConnect for Oracle
Topic: Preserve blanks in CHAR columns
Replies: 6
Views: 2977

Preserve blanks in CHAR columns

In our tables, we have columns defined as CHAR(1). These columns can contain alpha numeric values, blanks included.
With OraDirect 4.70.38.0 all the blanks are trimmed. That is, after executing a SELECT with one of these CHAR-columns which contain only one blank, we'll get back an empty string and not a string with one blank.

In an older post (back in 2004), you mentioned "... a special option to OracleCommand...". Unfortunately, I'm not able to find this magic thing...