| From: | tolik(at)icomm(dot)ru (Anatoly K(dot) Lasareff) |
|---|---|
| To: | Brian Baquiran <brianb(at)evoserve(dot)com> |
| Cc: | Ghita Voda <gvoda(at)smartsoft(dot)ro>, "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgreSQL(dot)org> |
| Subject: | Re: [SQL] Insert a long text |
| Date: | 1999-02-19 12:25:50 |
| Message-ID: | 87ww1ed1gx.fsf@tolikus.hq.aaanet.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
>>>>> "BB" == Brian Baquiran <brianb(at)evoserve(dot)com> writes:
>> 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.
BB> What data type are you using for the text field? As far as I know, the 'text'
BB> datatype can only take 8K.
BB> I don't know what the maximum size for varchar is.
BB> Brian
8K is maximum length of whole record. In your case you must use 'large
objects' as datatype for big text.
--
Anatoly K. Lasareff Email: tolik(at)icomm(dot)ru
Senior programmer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Grimme | 1999-02-19 13:22:34 | SQL-Query 2 get primary key |
| Previous Message | Brian Baquiran | 1999-02-19 12:03:03 | Re: [SQL] Insert a long text |