I have a site that is in English but has a lot of German and Spanish names in it. Originally I was using UTF8, but that gave me problems with some of the German special characters. So I switched to: ISO 8859, but then the german characters were fixed but it broke all the Spanish ones. I changed to ISO 8859 in the wp-config file, but it seems like phpmyadmin doesn't even give me the option to choose ISO 8859.
This might be tolerable but after fixing all the accents using special characters, if you later change anything on the page all the accents break again and you have to insert all the special characters again!
Thanks in advance!!!