Host vars and code page conversion

From: Aakash Bordia <a_bordia_at_hotmail.com>
Date: Fri, 24 Oct 2003 11:52:25 -0700
Message-ID: <bnbsga$bf5$1@hanover.torolab.ibm.com>

Hello,
Does anybody know what is the documented and known behavior of inserting/updating binary columns using host variables from a client to a server which have different code pages? Will any code page / character set conversion take place? I am particulary interested in insert/update from subqueries.

eg:
insert into t1(binarycol) select :HV1 from t2 versus
insert into t1(binarycol) select :HV1||charcol from t2

update t1 set bytecol=:HV1
versus
update t1 set bytecol=:HV1||'abc'

insert into t1 (bytecol) values(:HV1)
versus
insert into t1 (bytecol) values(:HV1||'abc')

Is the conversion dependent on the context? Thanks
Aakash Received on Fri Oct 24 2003 - 13:52:25 CDT