Re: TOAST and TEXT - Mailing list pgsql-hackers

From Marko Kreen
Subject Re: TOAST and TEXT
Date
Msg-id 20011010044842.A10227@l-t.ee
Whole thread Raw
In response to TOAST and TEXT  (Chris Bitmead <chris@bitmead.com>)
List pgsql-hackers
On Wed, Oct 10, 2001 at 11:33:04AM +1000, Chris Bitmead wrote:
> So my question is, I assume TEXT is the best data type to store
> large things in, what precisely is the range of characters that
> I can store in TEXT? Is it only characters ascii <= 127, or is
> it only printable characters, or everything except '\0' or what?

text accepts everything except \0, and also various funtions
take locale/charset info into account.

Use bytea, its for 0-255, binary data.  When your client
library does not support it, then base64 it in client side
and later decode() into place.

-- 
marko



pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: What about CREATE OR REPLACE FUNCTION?
Next
From: Tatsuo Ishii
Date:
Subject: Re: Mule internal code ?