Hi,

I have a table which stores image files in BLOBs. No matter what I try, the 
data is always stored in place. I have tried column types BLOB and 
BLOB(100000000), and I have set MAX_LENGTH_INPLACE_LOB to 256. Originally 
the column was just BLOB but I wondered whether what causes them to be 
placed in separate files is the explicit precision of the type rather than 
the actual size of the value, hence changing it to 100000000. Since this is 
clearly greater than 256 all of them should be stored separately but this 
is not what's happening. I'm assuming that the BLOB precision and 
MAX_LENGTH_INPLACE_LOB are both in bytes, is that correct? Is there 
something I'm missing here? I did wonder if perhaps the DB would only start 
to store BLOBs in separate files if its total size had exceeded some 
threshold but I can't find anything about this in the documentation.

Thinking that there was something wrong with the DB, I created a new one 
using the H2 console. I created a table with a primary key and a 
BLOB(100000000), set MAX_LENGTH_INPLACE_LOB to 256 and inserted a 693KB 
JPEG using FILE_READ. I then inserted a 4.27MB PNG with the same approach. 
Both images were stored in place.

Here is my DB URL: jdbc:h2:[the path]

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/h2-database/-/T40MT4tSne8J.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to