Hi I am trying to update a blob column from Ruby script into MySQL DB.
The script is running on PC and DB on Linux host.
The problem I see is that only 255 bytes of data being stored ,
is there any way to deal with that problem ?
myconnect = Mysql::new(host, user, "", db)
f = File.new(file_name,'rb')
data = Mysql.escape_string(f.sysread(f.size))
update_sql = "update SHARE set COMPANY_LOGO = '"+ data + "' WHERE ID =
stmt = myconnect.prepare(update_sql)
I also tried to leave a - '?' mark and than fill it with data, that one
is not storing anything.