Dear Oleg, this is the debug output and the repr(sb) 1/QueryAll: SHOW COLUMNS FROM unit '???' 1/QueryIns: INSERT INTO unit (code) VALUES ('???') 1/QueryOne: SELECT code FROM unit WHERE id = (30)
and in this case i can see ??? in the field too and this is the output if i want to insert áéí 1/QueryAll: SHOW COLUMNS FROM unit '\xc3\xa1\xc3\xa9\xc3\xad' 1/QueryIns: INSERT INTO unit (code) VALUES ('áéí') 1/QueryOne: SELECT code FROM unit WHERE id = (31) Wednesday, August 30, 2006, 2:48:24 PM, you wrote: OB> On Wed, Aug 30, 2006 at 02:05:46PM +0200, Ivan Horvath wrote: >> sb = u'???'.encode('utf-8') OB> print repr(sb)? >> but when i try to insert the same thing with SQLObject the system >> inserts something different to the table: >> >> this is my py code >> connString = "mysql://root:[EMAIL >> PROTECTED]/vss_history?use_unicode=1&debug=1" >> __connection__ = connectionForURI(connString) >> >> class Unit(SQLObject): >> class sqlmeta: >> fromDatabase=True >> >> Unit(code=u'???') OB> What is the debugging output? OB> Oleg. -- Best regards, Ivan Horvath Chief Programmer Alcatel ISD PMS 2000 Product Team H-1116, Budapest Kondorfa u. 10. Tel.: +36 1 209 9546 Fax.: +36 1 209 9599 Mobil: +36 30 257 0235 VOIP: +49 511 676 478010 mailto:[EMAIL PROTECTED] Anyone who has never made a mistake has never tried anything new. /Albert Einstein/ ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss