Hi, > For me personally this description left many questions open and I would > have been better served with some > more background and details about the type. > > Do you feel that the current documentation is as complete as it can get?
Of course there is nothing ideal in this world.. But I agree with Dario that it's better to add links than copy/paste since bloated documentation is not very good too. I would propose such a change but I don't know how to correctly include links to the documentation. It seems to be not so strightforward.. > VARCHAR/CLOB and VARBINARY/BLOB are very different implementation artifacts. > > VARxx are limited to a maximum size (to 256/2048/.. chars dbm dependent ) and > behave exactly are char or small varchars in terms of in what > grammar,functions and operators can be used in. > > On the other hand, LOBS born to handle large objects with "LOCATORS" > semantics. > (http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db...) > > A locator is a pointer to large object's internal content on the server side, > that can be used to handle the large object without reading it completely > from the client side; and with streaming support for reading and writing the > full content. > (http://download.oracle.com/javase/6/docs/api/java/sql/Clob.html) > LOB data type can't be used with most operators and have restricted usage in > select clauses. Good point. But currently in h2 there is no "locators" and LOBs are sent to the client the same way as BINARY/VARCHAR, so now the main difference is that BINARY always represented as byte array and have to always fit in memory while LOBs are operated via InputStreams and have no such a restriction but can be slower sometimes. regards, Sergi -- 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.
