List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:May 26 1999 4:23pm
Subject:Re: CHAR and VARCHAR
View as plain text  
Ritschie wrote:
> 
> Hi,
> 
> Can anyone please tell me what is the differnce between char and varchar?
> When is it good to use char and when is it good to use varchar?
> 
> Ritschie
> 
> http://ludens.elte.hu/~krichard
> 
> ---------------------------------------------------------------------

char is fixed length, varchar variable length as
evidenced by the name.

char is good for speed, varchar for storage space,

more details in the manual.

-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
Thread
AUTOINCREMENT & INSERT ...Sandrine C.26 May
  • Re: AUTOINCREMENT & INSERT ...Erik Liljencrantz26 May
Re: AUTOINCREMENT & INSERT ...jkraai26 May
Re: AUTOINCREMENT & INSERT ...Sandrine C.26 May
  • Re: AUTOINCREMENT & INSERT ...Paul DuBois26 May
    • CHAR and VARCHARRitschie26 May
      • Re: CHAR and VARCHARSasha Pachev26 May
      • Re: CHAR and VARCHARJim Faucette26 May
Re: AUTOINCREMENT & INSERT ...Nick Rawlings27 May