Dear Nadav,
unfortunately i receive now the same error, when i try to insert
some non ascii characters.
the strange is that my system gives the db_encoding as latin-1,
but my table collation is utf-8.
so do you have any solution inserting non ascii characters to a
unicode mysql table?
Monday, July 10, 2006, 1:00:42 PM, you wrote:
NS> Hi,
NS> Thanks, but I get the same exception. It seems that the only role of
NS> use_unicode is to force StringCol's to be UnicodeCol's. My columns are
NS> already UnicodeCol's.
NS> Nadav
NS> On 7/10/06, Ivan Horvath <[EMAIL PROTECTED]> wrote:
>> Dear Nadav,
>>
>> try using the connection string with use_unicode parameter
>> e.g.
>> connString = "mysql://root:[EMAIL PROTECTED]/test?use_unicode=1"
>> __connection__ = connectionForURI(connString)
>>
>>
>> Saturday, July 8, 2006, 12:54:35 PM, you wrote:
>>
>> NS> Hi,
>>
>> NS> I am using SQLObject-0.8dev_r1814, MySQLdb 1.2.1_p2 and MySQL 5.0.22
>> NS> on Arch Linux.
>> NS> I am using fields of type UnicodeCol. When I try to insert such object
>> NS> to the database I get
>> NS> an exception which originates in MySQLdb:
>>
>> NS> File
>> NS>
>> "/usr/lib/python2.4/site-packages/SQLObject-0.8dev_r1814-py2.4.egg/sqlobject/mysql/mysqlconnection.py",
>> NS> line 66, in _executeRetry
>> NS> return cursor.execute(query)
>> NS> File "/usr/lib/python2.4/site-packages/MySQLdb/cursors.py", line
>> NS> 146, in execute
>> NS> query = query.encode(charset)
>> NS> UnicodeDecodeError: 'ascii' codec can't decode byte 0xd7 in position
>> NS> 196: ordinal not in range(128)
>>
>> NS> I tried to pass the data both as unicode strings and as normal strings
>> NS> with utf8 encoding.
>>
>> NS> It seems like SQLObject is sending the query to MySQLdb as a normal
>> NS> string, encoded in utf8. But, MySQLdb excepts it to be a unicode
>> NS> string, because lines 145-156 in cursors.py are:
>>
>> NS> charset = db.character_set_name()
>> NS> query = query.encode(charset)
>>
>> NS> Also, it turns out that the value of charset is 'latin1'. I am not
>> NS> sure why it is so, but I could force it to be 'utf8' if I changed the
>> NS> connect() call in makeConnection() method of mysqlconnection.py to
>> NS> have a keyword argument charset='utf8'.
>> NS> Of course it does not help, since SQLObject already sends an encoded
>> string.
>>
>> NS> Any Ideas?
>>
>> NS> Thanks,
>> NS> Nadav
>>
>> NS> Using Tomcat but need to do more? Need to support web services, security?
>> NS> Get stuff done quickly with pre-integrated technology to make your job
>> easier
>> NS> Download IBM WebSphere Application Server v.1.0.1 based on Apache
>> Geronimo
>> NS> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>> NS> _______________________________________________
>> NS> sqlobject-discuss mailing list
>> NS> [email protected]
>> NS> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>>
>>
>>
>> --
>> 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
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>>
NS> -------------------------------------------------------------------------
NS> Using Tomcat but need to do more? Need to support web services, security?
NS> Get stuff done quickly with pre-integrated technology to make your job
easier
NS> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
NS> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
NS> _______________________________________________
NS> sqlobject-discuss mailing list
NS> [email protected]
NS> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
--
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
