| From: | Marko Kreen <marko(at)l-t(dot)ee> |
|---|---|
| To: | Chris Bitmead <chris(at)bitmead(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: TOAST and TEXT |
| Date: | 2001-10-10 02:48:42 |
| Message-ID: | 20011010044842.A10227@l-t.ee |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2001-10-10 03:06:04 | Re: Mule internal code ? |
| Previous Message | Christopher Kings-Lynne | 2001-10-10 01:57:10 | Re: [HACKERS] What about CREATE OR REPLACE FUNCTION? |