The default character set used by MySQL for the connection is latin1.
If you control the server, you can configure this in the system my.cnf.
Otherwise, it is possible to set it in a local configuration file and
use the read_default_file option to connect to set it.
http://dev.mysql.com/doc/mysql/
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