Re: Field Size

Поиск
Список
Период
Сортировка
От Marc A. Leith
Тема Re: Field Size
Дата
Msg-id 20031208130328.28EC730AE1C@appsrv1.nuvergence.com
обсуждение исходный текст
Ответ на Re: Field Size  ("Ganesan Kanavathy" <ganesh@magnusquest.com>)
Список pgsql-admin
Дерево обсуждения
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 MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";}

Can anyone tell me, what harm would setting a field size to 1000 characters do to the size?



By increasing the size, will the database require more space? Or does it only consume space if there is data in the field only?



Regards,

Ganesan





Marc A. Leith
President
redboxdata inc.

e-mail: marc@redboxdata.com
cell:    (416) 737 0045

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Ganesan Kanavathy"
Дата:
Сообщение: Re: Field Size
Следующее
От: "Somasekhar Bangalore"
Дата:
Сообщение: Re: Field Size