Re: [GENERAL] char o varchar

[Andreas Fromm]

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