I run a service that lets peaople submit their sites with descriptions, titles etc.

The problem is they come from all over the world, and I'd need to support multiple languages.

I use UTF8 encoding (with general collatation), but it's not working well. For example when you insert spanish letters then it displays some weird chars.

I'm guessing the solution would be to create seperate table with different collatations:
ie.
spanish => utf8_spanish_ci
german =? utf8_german_ci
etc..
Correct?

And another question: is it possible to refresh and regain those corrupted characters?

Last question: how to distiguish with php what's the encoding of inserted data?

thanks.