convert text field from one charset to another

[itaym02]

Greetings

I need to convert the charset of all the text fields in my db to utf-8.
Can I do it via SQL alone or do I need some server side programming?

A link to some article will suffice, altough I wouldn't mind a complete answer.

Thanks