Re: [SQL] Insert a long text

Поиск
Список
Период
Сортировка
От Brian Baquiran
Тема Re: [SQL] Insert a long text
Дата
Msg-id Pine.OSF.3.91.990219200042.15691A-100000@athena.evoserve.com
обсуждение исходный текст
Ответ на Insert a long text  (Ghita Voda <gvoda@smartsoft.ro>)
Список pgsql-sql
On Fri, 19 Feb 1999, Ghita Voda wrote:

> Hello!
>
> I want to insert a long text (up to 10.000 words) into a table (for example, table1) into a field (field1) which is a
'text'field. 
> I have tried the followings:
> INSERT INTO table1 VALUES (' long text'...)
> UPDATE table1 SET field1='long text'
> and is not working.
> I'm using servlets and Apache server, on Linux.

What data type are you using for the text field? As far as I know, the 'text'
datatype can only take 8K.

I don't know what the maximum size for varchar is.

Brian
--
"No matter how cool your interface,
  it would be better if there were less of it"  -- Alan Cooper


В списке pgsql-sql по дате отправления:

Предыдущее
От: Ghita Voda
Дата:
Сообщение: Insert a long text
Следующее
От: tolik@icomm.ru (Anatoly K. Lasareff)
Дата:
Сообщение: Re: [SQL] Insert a long text