>>>>> "BB" == Brian Baquiran <brianb@evoserve.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@icomm.ru
Senior programmer