On Tue, Sep 26, 2006 at 03:59:06PM -0400, Nathan Edwards wrote: > > Invalid: expected an date/time string of the '%H:%M:%S' > format in the DateTimeCol 'col3', got <type 'datetime.timedelta'> > datetime.timedelta(0, 56256) instead
Never saw such an error. Puzzled... > > ProgrammingError: (1064, "You have an error in your SQL syntax; > check the manual that corresponds to your MySQL server version for the > right syntax to use near 'NULL)\n)' at line 3") Ha! MySQL! MySQL doesn't allow NULLs in EnumCol. There is a patch in the SF tracker: http://sourceforge.net/tracker/index.php?func=detail&aid=1496014&group_id=74338&atid=540672 and it would be helpful if you review and comment it. > [/.../SQLObject/sqlobject/tests/test_blob.py:18] > > E myquery = unicode(query, self.encoding) > > UnicodeDecodeError: 'ascii' codec can't decode byte > 0x80 in position 167: ordinal not in range(128) MySQLdb 1.2.1+? You have to specify an encodings in DB URI: mysql://host/db?debug=1&charset=utf-8&sqlobject_encoding=utf-8 for example. "charset" is for DB encoding, sqlobject_encoding is for client encoding. Oleg. -- Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
