Обсуждение: Difference between VARCHARs

Поиск
Список
Период
Сортировка

Difference between VARCHARs

От
Robert.Farrugia@go.com.mt
Дата:
What difference does it make between declaring a field as VARCHAR(N) where
N is an integer and declaring it just VARCHAR without giving the length ?

Regards
Robert


Re: Difference between VARCHARs

От
Peter Eisentraut
Дата:
Robert.Farrugia@go.com.mt writes:

> What difference does it make between declaring a field as VARCHAR(N) where
> N is an integer and declaring it just VARCHAR without giving the length ?

The former has a length limit, the latter doesn't.

http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/datatype-character.html

--
Peter Eisentraut   peter_e@gmx.net