Hello! I am using mySql 5.0.45
By default the collation of text columns is set to latin1_swedish_ci
I am wondering if I should change these to utf8, in particular on particular column I know for sure that text will be in utf8 encoding. I parse rss feeds and know that the output text will be in utf8.
Should I change the collation to utf8? Also, why there are so many different types of utf8 variations - like utf8_danizh, utf8_latvian, etc...
I thought utf8 is supposed to be a universal standard encoding format that solves this exact problem of choosing an encoding - almost any character from almost any language can be represented in utf8. Then why are there so many utf8 collation choices in mysql and which one should I choose?
Last question, what if I just stick with latin1_swedish_ci? Whould it really make any difference?