VARCHAR type with or without length
758 views
Skip to first unread message
Steve Luo
Feb 4, 2011, 12:21:09 PM2/4/11
to H2 Database
Hi,
I found that if the length of VARCHAR type is not specified, H2 will
use a default length: 2147483647. And this is very useful for me. But
my question is that will it make the size of my database increase or
not, and will it affect the performance or not ?
I found that if the length of VARCHAR type is not specified, H2 will
use a default length: 2147483647. And this is very useful for me. But
my question is that will it make the size of my database increase or
not, and will it affect the performance or not ?
Thomas Mueller
Feb 5, 2011, 6:24:59 AM2/5/11
to h2-da...@googlegroups.com
Hi,
> will it make the size of my database increase
No.
> will it affect the performance
No.
Regards,
Thomas
James Moger
Feb 8, 2011, 8:20:27 AM2/8/11
to h2-da...@googlegroups.com
Interesting. So is there a difference between VARCHAR of unspecified length and CLOB?
Thomas Mueller
Feb 10, 2011, 12:19:04 AM2/10/11
to h2-da...@googlegroups.com
Hi,
> Interesting. So is there a difference between VARCHAR of unspecified length
> and CLOB?
Yes, see
http://h2database.com/html/datatypes.html#varchar_type
http://h2database.com/html/datatypes.html#clob_type
Regards,
Thomas
Reply all
Reply to author
Forward
0 new messages