Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

when inserting space into column

657615Sep 1 2008 — edited Sep 8 2008
Hi,

I have a little problem with space inserting into column. When doing smt like this:

create table test (a varchar2(10), b varchar2(50));

insert into test (' ', 'space');
insert into test ('', 'empty string');
insert into test (null, 'null');

in sqlplus then nothing is wrong. In db reference (10g) I can read, that second and third insert for a column 'a' will be used the same way - null in db.
But when used odbc first insert gave me null in column 'a' as well.

Any idea how to force odbc to do not convert space into null?

- - - -
ps: sorry for any mistakes in gramar and vocabulary ;)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 6 2008
Added on Sep 1 2008
3 comments
2,945 views