Hi,

after upgrade 1.1.5 to 1.2 all the őŐűŰúÚ letters are not allowed. I get "?" character. I've tried to edit desc with phpmyadmin, but i got Warning: #1366 Incorrect string value: '\xC5\xB1z' for column 'desc' at row 1 error. (word "t?z" -> "tűz").
These characters are allowed in tags.

The images what has éáüö... characters in name are not shown. Got error: MySQL Query ( SELECT * FROM zp_images WHERE filename = 't�ren_0007.JPG' AND albumid = '49' LIMIT 1; ) Failed. Error:Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_unicode_ci,COERCIBLE) for operation '='

How can i fix these problems?
thanks.

Slidey

http://www.zenphoto.org/2008/08/troubleshooting-zenphoto/#28

Thank you sbillad, but it is just a half solution to not use these letters in filenames. remember 1.1.5 works correctly with it.
Still can't use these letters in description, title... But these letters are shows correctly in tag.
The tags are in another database? no, so we are at the first question again. By the way, the site is utf-8 too, so it must be good.

Thank you,
Slidey

Ok, i checked the tables closer. The table is utf-8, but desc, title are latin-swedish. After to change them to utf-8, the characters are shows correct.

The description and titles came from the filenames, thus they were Latin1. The problem is not so much in fixing the titles--that is easily done. It is that the filenames stored in the database will get truncates causing other problems. I choose to leave the issue visible by not fixing the titles so people will know that those characters are causing problems.

In the last few days, i didn't informed about bug on my site. So this "solution" is works for me.
The files are renamed, and title and desc set to utf-8.
Thanks.