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 padded. I.e. if you create a table with char(8) and insert 'abc' then select it, you'll get 'abc ' back, i.e. abc followed by padding spaces to make it 8 wide. Most of the time this is not what the user wants. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])