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

size of varchar

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: size of varchar
Date: 2007-03-23 01:39:10
Message-ID: 46032FBE.6050102@gmx.net (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

I'm migrating an Access application to use PG as backend.
In the access-mdb I have every varchar set to use max. 255 chars because 
on the one hand Access can't have bigger varchars and on the other hand 
Access won't need more room for 10 chars in a varchar(255) than in a 
varchar(10).
Therefore I have never figured out the really necessary size for 
zip-codes, names, phone numbers and what not.

Can I stay with size 255 in PG without getting a space- or speed-penalty ?
I'll use ODBC. Is the size 255 relevant in network transfers ?


regards
A.

Responses

pgsql-novice by date

Next:From: Richard Broersma JrDate: 2007-03-23 04:55:09
Subject: Re: size of varchar
Previous:From: AndreasDate: 2007-03-22 23:04:44
Subject: Re: installing on windows XP

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