text vs varchar(n) - Mailing list pgsql-general

From Richard Emberson
Subject text vs varchar(n)
Date
Msg-id 3C70969E.1C87D77@phc.net
Whole thread Raw
Responses Re: text vs varchar(n)  (Einar Karttunen <ekarttun@cs.helsinki.fi>)
Re: text vs varchar(n)  (Jean-Michel POURE <jm.poure@freesurf.fr>)
List pgsql-general
Couple of questions:

If ones sets up the db to be UNICODE, does that also apply to the 'text'
type?

Which is faster read and write, a table with text or varchar types:

create table text_table (
id   bigint,
value text
);

or

create table varchar_table(
id bigint,
value varchar(1024)
);

Why would one every use varchar(n) instead of text (aside from non-sql
standard)?

Thanks.

Richard


pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Database Performance?
Next
From: Tom Lane
Date:
Subject: Re: calculating spherical distance in sql