Hi,
I'm using SQLObject 0.7b1 and MySQL with a UTF-8 charset, all my string
columns are declared as UnicodeCol and I use Oleg's to_utf8 function encoding
all values I pass to a column in UTF-8. Anyway each time I try to update or
insert an object with unicodes values (accentuated characters,..) I get a
Unicode Error, for example, with an update:
------
2006-07-17T16:28:00 ERROR root
C:\Python24\Lib\site-packages\zope\publisher\publ
ish.py line 143 in publish
=> 'publication.afterCall(request, object)'
** exceptions.UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in
positi
on 59: ordinal not in range(128)
C:\Python24\Lib\site-packages\zope\app\publication\zopepublication.py line 167
i
n afterCall
=> 'txn.commit()'
** exceptions.UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in
positi
on 59: ordinal not in range(128)
C:\Python24\Lib\site-packages\transaction\_transaction.py line 372 in commit
=> 'self._callBeforeCommitHooks()'
** exceptions.UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in
positi
on 59: ordinal not in range(128)
C:\Python24\Lib\site-packages\transaction\_transaction.py line 421 in
_callBefor
eCommitHooks
=> 'hook(*args, **kws)'
** exceptions.UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in
positi
on 59: ordinal not in range(128)
c:\ZopeInst\lib\python\sqlos\_transaction.py line 43 in beforeCommitHook
=> 'obj.sync()'
** exceptions.UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in
positi
on 59: ordinal not in range(128)
c:\python24\lib\site-packages\SQLObject-0.7.1b1-py2.4.egg\sqlobject\main.py
line
991 in sync
=> 'self.syncUpdate()'
** exceptions.UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in
positi
on 59: ordinal not in range(128)
c:\python24\lib\site-packages\SQLObject-0.7.1b1-py2.4.egg\sqlobject\main.py
line
1011 in syncUpdate
=> 'self._connection._SO_update(self, values)'
** exceptions.UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in
positi
on 59: ordinal not in range(128)
c:\python24\lib\site-packages\SQLObject-0.7.1b1-py2.4.egg\sqlobject\dbconnection
.py line 563 in _SO_update
=> 'self.query("UPDATE %s SET %s WHERE %s = (%s)" %'
** exceptions.UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in
positi
on 59: ordinal not in range(128)
I get other errors when inserting, but they are all related to unicode. Any
idea on what's happening,
Thanks,
Stéphane
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
