Re: arabic text insertion problem

[Geert Vanderkelen]

First fixing your Python code: you should do it this way (category and name can be input from some website):

db = my.connect(user='root',db='test',charset='utf8')
cur = db.cursor()
name = 'a'
category = '\xd8\xb6'
s = "INSERT INTO animal (name, category) VALUES (%s,%s)"
cur.execute(s, (name,category))


Next, '\xd8\xb6' is not 'latin1', it's also not part of the Arabic character encoding ISO-8859-6 (please correct me if I'm wrong).
If you set the the charset to utf8 as shown above, it should work.
You got to make sure your input is UTF8, and I think it is, at least '\xd8\xb6' is.

Geert Vanderkelen
Software Developer at Oracle