If you define the field as CHAR, 1000 bytes will be consumed.
If you define the field as VARCHAR, on sufficient bytes to store the contents will be used.
Marc
--Original Message Text---
From: Ganesan Kanavathy
Date: Mon, 8 Dec 2003 20:56:06 +0800
Clean Clean DocumentEmail MicrosoftI
There is no harm in having a field size of 1000 character provided u use
the proper datatype. Don’t user char(1000). Try using varchar(1000).
For character data it is recommended to
use the VARCHAR type, since PostgreSQL manages it very well. On the
contrary, if you use the CHAR dataty
On Mon, Dec 08, 2003 at 18:36:57 +0530,
Somasekhar Bangalore <[EMAIL PROTECTED]> wrote:
> There is no harm in having a field size of 1000 character provided u use the proper
> datatype. Don't user char(1000). Try using varchar(1000).
And if the 1000 limit is just a large number you picked rathe
