Skip site navigation (1) Skip section navigation (2)

varchar vs char vs text

From: Singer Wang <swang(at)cs(dot)dal(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: varchar vs char vs text
Date: 2002-02-12 20:19:54
Message-ID: 20020212161954.C27959@cs.dal.ca (view raw or flat)
Thread:
Lists: pgsql-novice
if I have a column that's gonna be between 5-300 charactors...  should I go with a
a charactor? varchar? or a text?

what's the performance penalty going with a text instead of a varchar... or a char?
I don't need to index it.... nor search based on it..

-- 
Singer XJ Wang - swang(at)cs(dot)dal(dot)ca - ICQ: 201253
-------------------------------------------------------------------------
   "WAR stands for We Are Right!"

Responses

pgsql-novice by date

Next:From: Jason EarlDate: 2002-02-12 20:41:03
Subject: Re: varchar vs char vs text
Previous:From: Jason EarlDate: 2002-02-12 20:11:32
Subject: Re: Database size

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group