3
(click on this box to dismiss)
Please provide an example of using blob_from_file in an update or insert statement reading a file from /tmp/
For Example
UPDATE tblfile SET fileimage = BLOB_FROM_FILE ('/tmp/image.png') WHERE fileid = '2b93d4629241d287915a422f6d1a90374de95ef0'
BUT
This is giving me a Cannot coerce blob to type unknown data type error.
fileimage is a blob
link
comment (6)
asked last year
26
This seems to be reported as a bug. You can expect to see it fixed in the very near future - ![[Level:7]](http://www.cubrid.org/modules/point/icons/default/7.gif "Rank: 7/30, reputation score 491 (91% completed for the next level)")
ginarrbrik last year
ginarrbrik last year Any idea when this may be, I need this functionality working for a system I am doing - ![[Level:2]](http://www.cubrid.org/modules/point/icons/default/2.gif "Rank: 2/30, reputation score 26 (20% completed for the next level)")
andrevanzuydam last year
andrevanzuydam last year @ginarrbrik, you had an example for INSERT using BLOB_FROM_FILE. Would you please share? That bug you're talking about, I guess, is related to using BLOB_FROM_FILE with SELECT. INSERT and UPDATE seems to work fine. Would you please confirm this? - ![[Level:8]](http://www.cubrid.org/modules/point/icons/default/8.gif "Rank: 8/30, reputation score 558 (28% completed for the next level)")
CUBRID last year
CUBRID last year Well, I have tried an update also, I tested this in the query manager just to make 100%. I had some thoughts also that there might be permission problems using this command, that is why I tried to load files from /tmp/ if there is a problem with permissions then this needs to be documented so everyone understands how this works. - andrevanzuydam last year
andrevanzuydam last year I can confirm that I have no joy with update or insert. - andrevanzuydam last year
andrevanzuydam last year We will get back to you with a solution. If not possible, we will tell you the reason. - CUBRID last year
CUBRID last year
1
Answer
asked last year
viewed 585 times