Re: [Hsqldb-user] VARCHAR with or without size?

[fredt <fr...@us...>]

For VARCHAR no extra space is allocated in either case. It is better to 
specify the size for future compatibility.

Fred

----- Original Message ----- 
From: "Detlef Rudolph" <ru...@gm...>
To: <Hsq...@li...>
Sent: 18 January 2008 22:05
Subject: [Hsqldb-user] VARCHAR with or without size?


Hello Group,

when i create tables, in hsqldb i can give varchars a
field length or not. What is better for access time,
to give a size because all records have the same size?
And seeking from record to record is faster? Or is the
access time independent from it?

Thanks for your answer,
Det

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Hsqldb-user mailing list
Hsq...@li...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user