Hi, I have problem with storing user names with accented characters. Problem is in the function user_get_id_by_name() in the query
SELECT * FROM mantis_user_table WHERE username='Adam Živnéř' Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' Which makes sense. Solution is simple: change charset of columns "username" and "realname" of "mantis_user_table" to UTF-8. The question is, why is UTF-8 not the default schema encoding? Not all users can detect or fix the problem ... I'm running on clean installation of recent CVS version (pre rc1) on MySQL 5.1.30, but I encountered the same problem on 5.0. -- S pozdravem Adam Živnéř | ICQ: 354-750-968 | Mobil: 775 610 300 ------------------------------------------------------------------------------ _______________________________________________ mantisbt-help mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mantisbt-help
