Using Python with MySql and Unicode Characters
To the Point:
To insert unicode values into MySql from Python, use these two parameters:
charset = “utf8″, use_unicode = True
db = MySQLdb.connect(host=”localhost”, user=”root”, passwd=”secret”,db=”dbname”,charset = “utf8″, use_unicode = True)
Additional Information:
You may also need to change the database encoding in your MySql database to utf8. Do something like this:
ALTER DATABASE DatabaseNameGoesHere DEFAULT CHARACTER SET UTF8;
