Re: TOAST and TEXT

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