Re: [GENERAL] Varchar and varchar2

> I've looked through the documentation, but I can't find the size of the
> limit of varchar...?
>
> All I found was in the User's Guide:
>
> Character Type          Storage         Description
> ---------------------------------------------------
> varchar(n)              (4+n) bytes     variable length with limit
> ---------------------------------------------------
>
> What does 4+n bytes mean?  And what is the limit?
>

It means that the minimem length will be 5 bytes and the maximum is the
maximum amount of characters that can be contained in a record
(aproximately 8000 bytes), where 4 bytes are most likely used to contain
the actual number of characters.  n, in the above expression most likely
represents the number of characters to be stored for a particular
instantition of this field.

>  Anyone? And is there support for varchar2?
>

What is varchar2?

...james