| From: | Brian Baquiran <brianb(at)evoserve(dot)com> |
|---|---|
| To: | Ghita Voda <gvoda(at)smartsoft(dot)ro> |
| Cc: | "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgreSQL(dot)org> |
| Subject: | Re: [SQL] Insert a long text |
| Date: | 1999-02-19 12:03:03 |
| Message-ID: | Pine.OSF.3.91.990219200042.15691A-100000@athena.evoserve.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anatoly K. Lasareff | 1999-02-19 12:25:50 | Re: [SQL] Insert a long text |
| Previous Message | Ghita Voda | 1999-02-19 10:00:48 | Insert a long text |