Hi, >And next question is, > How do I know "SET COMPRESS_LOB DEFLATE" effect ?
For this, I don't have an answer, sorry. What you could do is compress the data yourself, then you have control over how much it compresses. Regards, Thomas On Tue, May 13, 2014 at 8:48 AM, Tau <[email protected]> wrote: > Hi, > > Maybe, you understand correctly. > You said "select length(column) from tableName". > This is answer of my first question. > > And next question is, > How do I know "SET COMPRESS_LOB DEFLATE" effect ? > > Regards, > Tau > > 2014年5月13日火曜日 1時52分54秒 UTC+9 Thomas Mueller: >> >> Hi, >> >> Sorry, I think I misunderstood the question... The disk space usage is >> not available this way, sorry. I'm afraid I don't have a solution for this. >> >> Regards, >> Thomas >> >> >> >> On Mon, May 12, 2014 at 12:33 PM, Tau <[email protected]> wrote: >> >>> Thank you for your reply >>> >>> If I use "SET COMPRESS_LOB DEFLATE;", >>> How does it effect ? >>> Is result smaller than "246641 bytes" ? ( from previous example ) >>> >>> Regards, >>> Tau >>> >>> 2014年5月12日月曜日 14時43分35秒 UTC+9 Thomas Mueller: >>>> >>>> Hi, >>>> >>>> You could use "select length(column) from tableName", or you could use >>>> "select * from tableName", then use ResultSet.getClob(), and >>>> clob.getLength(). >>>> >>>> Regards, >>>> Thomas >>>> >>>> >>>> On Friday, May 9, 2014, Tau <[email protected]> wrote: >>>> >>>>> >>>>> I know function DISK_SPACE_USED. >>>>> And it exclude LOB (CLOB and BLOB) data size. >>>>> >>>>> If I use console, I can get BLOB size information. >>>>> like "aced00... (246641 bytes)". >>>>> >>>>> Could I get this information through JDBC ? >>>>> >>>>> Thanks, >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "H2 Database" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to [email protected]. >>>>> To post to this group, send email to [email protected]. >>>>> Visit this group at http://groups.google.com/group/h2-database. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> -- >>> You received this message because you are subscribed to the Google >>> Groups "H2 Database" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To post to this group, send email to [email protected]. >>> >>> Visit this group at http://groups.google.com/group/h2-database. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
