Hi, > 1. The doc says that h2.lobInDatabase defaults to "false". However, it appears to me this was changed to "true" in 1.3.x. I think the doc error is due to an obsolete javadoc comment in constant/SysProperties.java, around line 187.
You are right, this is a bug in the documentation. The default is now "true". > 2. If lobInDatabase is true, does the DEFAULT_MAX_LENGTH_INPLACE_LOB have any effect? Yes. But it may not be what you expect. It is the size to distinguish between small and large BLOB or CLOB values. Small values are stored together with the row, and large values in a separate place (within the database, or outside the database if "h2.lobInDatabase" is set to false). > I also see that in a fresh instantiation of H2, there is no value for DEFAULT_MAX_LENGTH_INPLACE_LOB in INFORMATION_SCHEMA.SETTINGS. Yes, only non-default values are listed. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. 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.
