hallo!
given the following table
create table s2 (a_key integer, a_varchar varchar(200))
for testing i have some scripts which makes inserts of chr(0) values like
insert into s2 (a_key, a_varchar) values (1, 'bla'||chr(0)||'bla2')
when i do this on a v7.2 database and i select it with a cli
application, then i get the 0 byte on the correct position. by the way a
select from the command line (db2cmd: db2 select * from s2) returns only
'bla' as value of the a_varchar column.
when i do this on v8 database, the cli application gets a 0x20 byte
value on the position of the 0 byte that means it gets a blank on the
position of the 0 byte. in this case the command line also returns the
wrong string with the blank instead of the 0 byte.
how can i get the old behavior?
thanks
andreas lederer