Oleg,

Interesting...

What I am getting when I run your example of handling a text data type is:

insert into dbo.test ([col1], [col2]) values (0x00000001, 0x73616d706c6520312c73616d706c652031);

insert into dbo.test ([col1], [col2]) values (0x00000002, 0x73616d706c6520322c73616d706c652032);

When I try to run these inserts into dbo.test, I get:

Operand type clash: varbinary is incompatible with text

Terry