When i try to update a varchar field the data is getting truncated
after it encounters '\x00' in between the data field:

Eg: data = "\x01\x02\x03\x00\x01\x02\x03".
The data available in the field is truncated to "\x01\x02\x03".

Do anybody know a solution for this.

The table schema is

CREATE TABLE TEST_TABLE (
FIRST VARCHAR(20) FOR BINARY WITH DEFAULT,
SECOND VARCHAR(10) WITH DEFAULT )

Vignesh,

How do you update this value? Through CLP? Script? or a program? If it
works when you issue the same update statement in the CLP, then problem
might be in your script or your program.

FYI: When I use below stmt in CLP,

update temp_table set first_Col = x'01020300010203' where second_col =
'1'

It went through fine.

Regards,

Mehmet Baserdem