[DB-SIG] mxODBC insert error. Reply

Chris Cogdon chris at cogdon.org
Thu Oct 14 23:03:32 CEST 2004


On Oct 14, 2004, at 13:13, Khawaja-Shahzad Butt wrote:

> All these Values are strings.

Just before you do the 'execute', can you put THIS statement:

print  
(item_dmodified,feed_item_title,item_author,feed_item_link,feed_item_fee 
ddescription)


Being in a tuple, this will case a repr of of the object to be sent. We  
think it likely that your strings have got non-ascii characters in  
them, and the database is barfing on them. I'm sure the database CAN  
accept non-ascii characters... but... it needs to be in the 'right'  
character set.


-- 
    ("`-/")_.-'"``-._        Chris Cogdon <chris at cogdon.org>
     . . `; -._    )-;-,_`)
    (v_,)'  _  )`-.\  ``-'
   _.- _..-_/ / ((.'
((,.-'   ((,/   fL



More information about the DB-SIG mailing list