* Lukasz Szybalski <[EMAIL PROTECTED]> [2006-04-14 12:00:09 -0500]:

> INSERT INTO table_x( body)VALUES( '%s')" %  (body)
> 
> this body is a string that varies in size. I keep getting an error if
> the size of body is longer then 255, and if its smaller everything
> goes smooth. Is this syntax correct? should '%s' be something else?

What is the datatype of body?  It sounds like it is CHAR(255).  Can you
change this to be TEXT?

Regards,
Andy

Send instant messages to your online friends http://uk.messenger.yahoo.com 
_______________________________________________
DB-SIG maillist  -  DB-SIG@python.org
http://mail.python.org/mailman/listinfo/db-sig

Reply via email to