Re: [GENERAL] char o varchar

2003-09-17 Thread Andreas Fromm
As of my knowlege, varchar as the choice when you have varying lenght strings, because only the real string lenght is stored in the db, while char is usefull when most of your records ar exactly the stringlenght defined by the column, because no overhead is to be kept for storing the actual str

Re: [GENERAL] char o varchar

2003-09-16 Thread scott.marlowe
On Tue, 16 Sep 2003, Edwin Quijada wrote: > > > > > Hoii!! > > I am creating my struct and I have the question : > What I must use for character fields char or varchar? > Which are the differences? and the better Generally speaking, varchar or text() types are preferred. char() types are p