Re: [GENERAL] Varchar and varchar2 - Mailing list pgsql-general

From James Olin Oden
Subject Re: [GENERAL] Varchar and varchar2
Date
Msg-id 81Jul5.155824edt.35713@gateway.lee.k12.nc.us
Whole thread Raw
In response to Varchar and varchar2  (Jeffrey Napolitano <jnapoli@setech.com>)
List pgsql-general


> 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


pgsql-general by date:

Previous
From: Paul Mullen
Date:
Subject: Re: [GENERAL] Alphabetical sorting...
Next
From: Roman Volkoff
Date:
Subject: unsubscribe