[opensuse] OT: character problems in mysql table
Hello 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! Daniel -- Daniel Bauer photographer Basel Barcelona http://www.daniel-bauer.com room in Barcelona: https://www.airbnb.es/rooms/2416137 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
Daniel Bauer wrote:
Hello
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. -- Per Jessen, Zürich (1.4°C) http://www.hostsuisse.com/ - dedicated server rental in Switzerland. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
participants (2)
-
Daniel Bauer -
Per Jessen