Ole,

<< No, the default length of 1 (if length is not specified) is the same for
both CHAR and VARCHAR. >>

Section 6.1 Data Types - The parentheses and length specifier are not
optional for VARCHAR, hence there is no "default".

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<< Section 6.1 Data Types - The parentheses and length specifier are not
optional for VARCHAR, hence there is no "default". >>

Yes, you're absolutely correct.

Ole Willy Tuv

Tim,

<< EDB allows you to specify a VARCHAR without a specific length. IOW, it
can grow as required. >>

Thinking about it - I actually like this EDB extension. It's basically a
short hand for:

VARCHAR(implementation_defined_max_length)

Btw, SQL Server 2005 has a similar extension - VARCHAR(max).

Ole Willy Tuv

Ole,

<< Thinking about it - I actually like this EDB extension. It's basically a
short hand for:

VARCHAR(implementation_defined_max_length)

Btw, SQL Server 2005 has a similar extension - VARCHAR(max). >>

Correct, but it is more Pascal-like to simply leave off the length.

--
Tim Young
Elevate Software
www.elevatesoft.com