Re: VARCHAR AND TEXT DATA TYPES - Mailing list pgsql-novice

From ries van Twisk
Subject Re: VARCHAR AND TEXT DATA TYPES
Date
Msg-id B56A6D80-9E6E-4812-8E9E-EAA2FFF07D33@rvt.dds.nl
Whole thread Raw
In response to VARCHAR AND TEXT DATA TYPES  ("JORGE MALDONADO" <jorgemal1960@gmail.com>)
List pgsql-novice
On Jan 5, 2009, at 5:44 PM, JORGE MALDONADO wrote:

> If I need a field of type character without size limit, should I use
> VARCHAR specifying no length or TEXT?
> What would be the difference?

Use Text, internally there is no difference between varchar and text
except that varchar has a added contraint with lenght.

>
> With respect,
> Jorge Maldonado


Ries




pgsql-novice by date:

Previous
From: "JORGE MALDONADO"
Date:
Subject: VARCHAR AND TEXT DATA TYPES
Next
From: "Nagle, Gail A \(US SSA\)"
Date:
Subject: Character Set UTF8 and libpq