pavanark
asked on
Data insertion into varbinary column
i have following table in the mysql.
create table test123 ( name varchar(30), binarynum varbinary(200)).
how to insert data into the table test123.
create table test123 ( name varchar(30), binarynum varbinary(200)).
how to insert data into the table test123.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Give an example of data you want to insert...
ASKER
for example
'123'
'100'
'123'
'100'
values that you can print can be inserted directly....
insert into test123 values ( "test", "123" );
insert into test123 values ( "test", "100" );
Non Printable data can be inserted using HEX values
insert into test123 values ( "test", "123" );
insert into test123 values ( "test", "100" );
Non Printable data can be inserted using HEX values
ASKER
lets say i have varchar(10) datatype value. i want to insert it into varbinary columns. how to do?