Should my MySQL database be set up as "UTF-8" ?? :-/
Why or why not?
If you want to store in your database texts with less common characters, or specific to other languages, it's better to use UTF-8.
Doesn't UTF-8 have a lot of "overhead" and like double the size of things?
Is it worth it?
I hate to make hasty decisions and regret things later, but I also have to be practical.
Bandwidth and disk space are dirt cheap, so I really really wouldn't worry about the extra bytes used by UTF-8.
Having said that, if you're not planning (ever) to support foreign characters, then there's no reason not to use latin-1.