Re: [SQL] Insert a long text

>>>>> "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