Re: TOAST and TEXT

Поиск
Список
Период
Сортировка
От Marko Kreen
Тема Re: TOAST and TEXT
Дата
Msg-id 20011010044842.A10227@l-t.ee
обсуждение исходный текст
Ответ на TOAST and TEXT  (Chris Bitmead <chris@bitmead.com>)
Список 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 по дате отправления:

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: What about CREATE OR REPLACE FUNCTION?
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Mule internal code ?