Byte encoding
Hi I am trying to do something a little strange but it is necessary.
I am writing out SQL as in a .sql text file so that I can run it on a few servers. One of the fields is a jpg image that I am trying to insert into a MEDIUMBLOB. The line will end up being -:
insert into fileBlob(fileId, data) values (123, $bytedata$);
Unfortunately I cant seem to convert the bytes into something the MySQL 5 database agrees with. The table encoding is latin-1 so I triednew String(bytes,"8859_1")
but that didn't work.
Can anyone assist please?

