mod_auth_mysql (apache2) and utf8 charset?

[mueller-w <mueller-w@besonet.ch>]

hallo!

i tried to setup mod_auth_mysql on apache2 (sarge) to use groups
authnetication (the user authentication works).

the group query fails with a mysql error:
ERROR 1267 (HY000): Illegal mix of collations
(latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for
operation 'find_in_set'

the same query using the mysql command line tool works. its charset is
set to utf8 (as is the database, the tables, the fields, the connection,
the collation). only mod_auth_mysql fails. (phpmyadmin can execute the
same query too)

i saw a 'AuthMySQLCharacterSet' option on another version of
mod_auth_mysql (at sourceforge) but that option does not seem to be
present on debian sarge.


is there a way to tell mod_auth_mysql which charset to use?

"apt-cache policy libapache2-mod-auth-mysql" tells me:
Installed: 4.3.9-2.dotdeb.0

thanks a lot :)