Settings to allow storing of strings consisting of one or more blanks?
Dear all,
I have a problem in Oracle 11 when trying to insert string values consisting of one or more blanks via bind parameters, namely that the Oracle OLEDB driver is converting such values to null. I know that a string of no characters is converted to a null value, and that is not a problem.
Example:
BEGIN INSERT INTO QTST_COLUMN_TEST2 (INT_KEY,INT_NOTNULL_1,INT_NOTNULL_2,DOUBLE_NOTNULL_1,DOUBLE_NOTNULL_2,STRING_NULL_1,STRING_NOTNULL_1,CHAR_NOTNULL_1,BOOL_NOTNULL_1,DATE_NOTNULL_1,USER_ID,UPDT_DT) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ); END;
where the bind value for STRING_NOTNULL_1 has the value ' ' (three blanks).
I have a problem in Oracle 11 when trying to insert string values consisting of one or more blanks via bind parameters, namely that the Oracle OLEDB driver is converting such values to null. I know that a string of no characters is converted to a null value, and that is not a problem.
Example:
BEGIN INSERT INTO QTST_COLUMN_TEST2 (INT_KEY,INT_NOTNULL_1,INT_NOTNULL_2,DOUBLE_NOTNULL_1,DOUBLE_NOTNULL_2,STRING_NULL_1,STRING_NOTNULL_1,CHAR_NOTNULL_1,BOOL_NOTNULL_1,DATE_NOTNULL_1,USER_ID,UPDT_DT) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ); END;
where the bind value for STRING_NOTNULL_1 has the value ' ' (three blanks).
0