Re: [PERFORM] [PERFORMANCE] Beetwen text and varchar field

2006-01-09 Thread Bruce Momjian
See the FAQ. --- Steinar H. Gunderson wrote: > On Mon, Jan 09, 2006 at 11:58:19AM +0100, TNO wrote: > > what is the best for a char field with less than 1000 characters? > > a text field or a varchar(1000) > > They will be

Re: [PERFORM] [PERFORMANCE] Beetwen text and varchar field

2006-01-09 Thread Steinar H. Gunderson
On Mon, Jan 09, 2006 at 11:58:19AM +0100, TNO wrote: > what is the best for a char field with less than 1000 characters? > a text field or a varchar(1000) They will be equivalent. text and varchar are the same type internally -- the only differences are that varchar can have a length (but does not