Home› General support

illegal charset mismatch in mysql queries

mav Member
in General support
I'm trying to set up a zenphoto gallery in a shared webhost space for someone who uploads image files with names in cp1251 russian encoding. When such an upload happens zenphoto throws a mysql error simiilary to "MySQL Error : Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp1251_general_ci,IMPLICIT)". I've gone through every table in my mysql 5 database and changed all charset references to cp1251_general_si and set the same default charset for every table and for the database. It seems that zenphoto mysql code doesn't honor the charset of the database it connects to.

The only somewhat relevant page I found in this forum is http://www.zenphoto.org/support/topic.php?id=227&replies=19 and it's not helpful.

Please help.

Comments

  • sbillard Member
    This is on our list for Internationalization. We hope to include that in the 1.2 release.
  • mav Member
    sbillard,

    Thanks a lot for answering! Now I know that at least I shouldn't give up on zenphoto and that it's inded a zenphoto problem and not something I'd done to the database. I'm looking forward to 1.2 release.

    Thanks,

    Alex.
Sign In or Register to comment.