Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

how to insert byte[] into mysql database

 
Moiez Gohar
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i want to store byte[] array in the first column (length of this byte array is always 16) and a BigInteger value (<10^78) in the second column. i used this code to create the table:


the table gets created successfully.

i have used this code to insert a row in this table :


i get the following error on executing the insert query:
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '_binary'Ç♥♦♣♠\"╨↑ºåà8K',1)' at line 1

i am using Connector/J JDBC on MySQL5.0 database..
please tell me why am i getting this error, and what should i do to remove this error, and achieve my objective of storing a byte[] array in the first field and a BigInteger value in the second field.
please guide me.
also, what are the corresponding SQL queries for inserting a byte[] array and a BigInteger?? what datatypes should i use??
please help me.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!