Solved

Data insertion into varbinary column

Posted on 2008-10-03
7
2,041 Views
Last Modified: 2011-09-20
i have following table in the mysql.
create table test123 (  name varchar(30), binarynum varbinary(200)).
how to insert data into the table test123.
0
Comment
Question by:pavanark
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
7 Comments
 
LVL 5

Accepted Solution

by:
libin_v earned 500 total points
ID: 22632005
Hi,

You I have answered your question in http://www.experts-exchange.com/Database/MySQL/Q_23777229.html

insert into test123 values ( "test", 0x2165489765464546748976465465798 );

You give the data in a Hex Format got instance "012345" in hex is 0x3031323333435 where
30 is ASCII value of 0
31 -> 1
...

So total you can insert values 00 to FF

0
 

Author Comment

by:pavanark
ID: 22632117
here you are inserting hex values.

lets say i have varchar(10)  datatype value. i want to insert  it into varbinary columns. how to do?
0
 
LVL 5

Expert Comment

by:libin_v
ID: 22632129
Give an example of data you want to insert...
0
 

Author Comment

by:pavanark
ID: 22632193
for example
'123'
'100'
0
 
LVL 5

Expert Comment

by:libin_v
ID: 22632232
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
0

Featured Post

 Watch the Recording: Learning MySQL 5.7

MySQL 5.7 has a lot of new features. If you've dabbled with an older version of MySQL, it is definitely worth learning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question