when inserting space into column
657615Sep 1 2008 — edited Sep 8 2008Hi,
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 ;)