consider posts
http://sourceforge.net/tracker/index.php?
func=detail&aid=1513168&group_id=22307&atid=374934
&
http://sourceforge.net/tracker/index.php?
func=detail&aid=1538924&group_id=22307&atid=374934
a patch is made.
it works under:
Python2.4.3
Zope2.9.4-finnal
MySQL-python-1.2.2b1
ZMySQLDA 2.0.9fix
with :
phpmyadmin2.8.2.4
php5.1.6
apache2.2.3
together finnaly
zmysqlda-2.0.9fix.diff
ZMySQLDA-2.0.9_fix.tgz
Logged In: YES
user_id=1597996
for mysql upgrade issue consider:
http://hostingfu.com/article/mysql-upgrade-and-unicode-
issues
also add a line in my.cnf:
[mysqld]
init_connect = 'SET NAMES utf8'
Logged In: YES
user_id=1597996
finnaly find out
actually , set this in my.cnf
[mysqld]
init_connect = 'SET NAMES utf8'
then there's no need to apply this patch
Logged In: YES
user_id=71372
Originator: NO
Use this instead:
[mysqld] (or [client])
default-character-set = utf8