[sqlalchemy] unable to add unicode characters such as ('軟件開發人員') to mysql database using sqlalchemy

2014-02-21 Thread Kin
Hello. i am not being able to write those traditional chinese characters to my mysql database. From my understanding of the link below: http://docs.sqlalchemy.org/en/rel_0_9/dialects/mysql.html I should have been able to write unicode characters to my mysql database, and be able to read them

Re: [sqlalchemy] unable to add unicode characters such as ('軟件開發人員') to mysql database using sqlalchemy

2014-02-21 Thread Michael Bayer
On Feb 21, 2014, at 2:42 PM, Kin kinrac...@gmail.com wrote: Hello. i am not being able to write those traditional chinese characters to my mysql database. From my understanding of the link below: http://docs.sqlalchemy.org/en/rel_0_9/dialects/mysql.html I should have been able to

Re: [sqlalchemy] unable to add unicode characters such as ('軟件開發人員') to mysql database using sqlalchemy

2014-02-21 Thread Michael Bayer
try the script I gave you, start with that. On Feb 21, 2014, at 5:17 PM, Kin kinrac...@gmail.com wrote: The python version is: 2.7.3 And while attempting to commit my change, this is the error message I obtained: UnicodeEncodeError: 'latin-1' codec can't encode characters in position

Re: [sqlalchemy] unable to add unicode characters such as ('軟件開發人員') to mysql database using sqlalchemy

2014-02-21 Thread Kin Rachid KONE KITO
I did. It is your script that gave me the error. i had to correct *object1 = Writers3(u'軟件開發人員’)* (as it gave me a syntax error due to the closing quote), then set the right Ips. The error I obtained come from that modified script. -- You received this message because you are subscribed to the