Re: [GENERAL] char o varchar

Wed, 17 Sep 2003 00:36:42 -0700

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




---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to