Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Difference between char and varchar
- From: Bruno Wolff III <bruno(at)wolff(dot)to>
- To: Richmond(dot)Dyes(at)monroehosp(dot)org
- Cc: pgsql-novice(at)postgresql(dot)org
- Subject: Re: Difference between char and varchar
- Date: Mon, 28 Aug 2006 19:10:19 -0500
On Mon, Aug 28, 2006 at 15:04:26 -0400, Richmond Dyes <rdyes(at)monroehosp(dot)org> wrote: > I know the difference between char and varchar is char is fixed length > and varchar returns variable length. Which one should be used and why? You normally want to use 'text' instead of either 'char' or 'varchar'. Unless there is a business rule limiting the length of a string (and sometimes not even then) you want to use 'text' as it is more flexible.
- Follow-Ups:
- Re: Difference between char and varchar
- From: Franck Routier
- Re: Difference between char and varchar
- References:
- Difference between char and varchar
- From: Richmond Dyes
- Difference between char and varchar
- Prev by Date: Difference between char and varchar
- Next by Date: Re: [GENERAL] Shared Objects (Dynamic loading)
- Previous by thread: Difference between char and varchar
- Next by thread: Re: Difference between char and varchar
- Indexes: