Re: char o varchar

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 stringlenght.

Regards

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
> TIA
>
> *-------------------------------------------------------*
> *-Edwin Quijada
> *-Developer DataBase
> *-JQ Microsistemas
> *-809-747-2787
> * " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de
> lo comun"
> *-------------------------------------------------------*
>
> _________________________________________________________________
> Charla con tus amigos en línea mediante MSN Messenger:
> http://messenger.yupimsn.com/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

--
Andreas Fromm

-----------------------------
Drink wet cement...
... and get stoned