Re: [GENERAL] Varchar and varchar2

Поиск
Список
Период
Сортировка
От James Olin Oden
Тема Re: [GENERAL] Varchar and varchar2
Дата
Msg-id 81Jul5.155824edt.35713@gateway.lee.k12.nc.us
обсуждение исходный текст
Ответ на Varchar and varchar2  (Jeffrey Napolitano <jnapoli@setech.com>)
Список 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 по дате отправления:

Предыдущее
От: Paul Mullen
Дата:
Сообщение: Re: [GENERAL] Alphabetical sorting...
Следующее
От: Roman Volkoff
Дата:
Сообщение: unsubscribe