Not allowed characters

Slidey

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

sbillard

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

Slidey

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

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.

sbillard

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.

Slidey

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.