CREATE TABLE testBINARY_dt1(a BINARY(8), b VARBINARY(10));
#inserting random values
INSERT INTO testBINARY_dt1(a, b) values (1234, 12345);
INSERT INTO testBINARY_dt1(a, b) values (NULL, NULL);
#INSERT INTO testBINARY_dt1(a, b) values (0x31323334, 0x3132333435);

CREATE TABLE testBINARY_dt2(a VARBINARY(max));
INSERT INTO testBINARY_dt2(a) values (NULL);

create table testBINARY_dt3 (a VARBINARY(max), b int, c int, d int, e int ,f int, g int, h int, i int);
insert into testBINARY_dt3 (a,b,c,d,e,f,g,h,i) values (NULL,1,2,3,4,5,6,7,8);

CREATE TABLE testBINARY_dt4(a BINARY(8), b VARBINARY(10));
INSERT INTO testBINARY_dt4(a, b) values (1234, 12345);
prepst#!# INSERT INTO testBINARY_dt4(a, b) values(@a, @b) #!#binary|-|a|-|1234#!#varbinary|-|b|-|12345
prepst#!#exec#!#binary|-|a|-|12345678#!#varbinary|-|b|-|12345
prepst#!#exec#!#binary|-|a|-|1234#!#varbinary|-|b|-|123456789