CREATE TABLE BINARY_dt(a BINARY(8), b VARBINARY(10));
#inserting random values
INSERT INTO BINARY_dt(a, b) values (1234, 12345);
INSERT INTO BINARY_dt(a, b) values (NULL, NULL);
#INSERT INTO BINARY_dt(a, b) values (0x31323334, 0x3132333435);
SELECT * FROM BINARY_dt
#prepst#!# INSERT INTO BINARY_dt(a, b) values(@a, @b) #!#binary|-|a|-|1234#!#varbinary|-|b|-|12345
DROP TABLE BINARY_dt


CREATE TABLE BINARY_dt(a VARBINARY(max));
INSERT INTO BINARY_dt(a) values (NULL);
SELECT * FROM BINARY_dt;
DROP TABLE BINARY_dt;

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