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

Re: Size or efficiency differences "varchar(128) vs. varchar(32)"

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: emilu(at)encs(dot)concordia(dot)ca
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Size or efficiency differences "varchar(128) vs. varchar(32)"
Date: 2008-07-21 16:17:04
Message-ID: dcc563d10807210917w5382e41an8355b0810a958213@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
On Mon, Jul 21, 2008 at 8:06 AM, Emi Lu <emilu(at)encs(dot)concordia(dot)ca> wrote:
> Good morning,
>
> I'd like to create a varchar length column.
>
> May I know does varchar(128) and varchar(32) will cause any size or
> efficiency differences?

If you store the same thing in each, no.  If you store 128 char  text
in the varchar(128) it will of course be bigger than a 32 char text in
the varchar(32) field.

In response to

pgsql-sql by date

Next:From: Emi LuDate: 2008-07-21 16:59:02
Subject: Re: Size or efficiency differences "varchar(128) vs. varchar(32)"
Previous:From: Alvaro HerreraDate: 2008-07-21 15:40:49
Subject: Re: Size or efficiency differences "varchar(128) vs.varchar(32)"

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