Re: char o varchar

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.