Thank you. New question concerning text encoding

Patrick Useldinger wrote: Just a guess "in the dark" (I don't use MySQL): is "commit" implicit, or do you have to add it yourself? Thank you. Inserts work fine now. Another question. I'm trying to insert Japanese text into the table. I created the database using 'CHARACTER SET UTF8'. In Python I

Can't seem to insert rows into a MySQL table

I'm trying to add a row to a MySQL table using insert. Here is the code: connection = MySQLdb.connect(host="localhost", user="root", passwd="pw", db="japanese") cursor = connection.cursor() cursor.execute("INSERT INTO edict (kanji, kana, meaning) VALUES (%s, %s, %s)", ("a", "b", "c") ) connection