Thanks Willem,
I think so. But I'm not exactly sure. My python code looks like this:

db =
MySQLdb.connect(host='localhost',user='root',passw d='somepassword',db='somedb')
c = db.cursor(MySQLdb.cursors.DictCursor)
c.execute("SET NAMES utf8")
c.execute("SET CHARACTER SET utf8")
c.execute("SET character_set_client=utf8")
c.execute("SET character_set_connection=utf8")
bigLongQuery = "INSERT INTO mytable ..... "
c.execute(bigLongQuery)
db.commit()
data = c.fetchall()
c.close()
db.close()

Can you tell if the above is correct?

As for the [mysql] section of my.ini, it sets "default-character-set=utf8".
Same goes for [mysqld].



"Willem Bogaerts" <w.bogaerts@kratz.maardanzonderditstuk.nl> wrote in
message news:47663cf2$0$85790$e4fe514c@news.xs4all.nl...
>> I've encountered a difficult unicode problem with MYSQL. My configuration
>> is:
> <snip>
>
> Do you send a "SET NAMES utf8;" command directly after connection?
> Otherwise, the mysql server may still default to latin-1. This is a bit
> server-dependent and you may take a second look at your settings file.
> the [mysql] section is just for the command-line client and not for
> others.
>
> Hope this helps,
> --
> Willem Bogaerts
>
> Application smith
> Kratz B.V.
> http://www.kratz.nl/