Daniel Bauer wrote:
I have a mysql table with names from all over the world. I usualy use latin1_german1_ci collation that goes fine also with characters from french (é, è...), spanish (ñ...), german (ä, ü...) but NOT with czech (ř...).
After asking big brother g I changed the text fields to collation latin2-general_ci. Czech is now fine, but the spanish "ñ" does not work anymore...
What do I have to do so that I can save characters of any language (I mean with our characters, not chinese etc.)?
Thanks a lot for any hints!
Create your database with default charset UTF8. Just do everything in UTF8.