Using/Converting to UTF8

[Theodosios Paschalidis]

Hi all.

I have just upgraded from 3.23.52 to 4.1.1 in order enable UTF8 support for Greek on a
windows system.

I have restored by database and I am wondering how I should go about it.

1) Is there any easy way to convert everything (my tables contain both english and greek
fields)  to utf? is the "CONVERT()"  the only way to do it? Can it be used for a whole
database?

2) Would using "CHARACTER SET character_set_name | DEFAULT"  be a solution? If yes how I
can add the required mapping since I used the binary distriburion and don't even have a
"convert.cc" to edit.

3) If the answear to 2 is NO, how can I use utf from now on? (either on a database or
table level)

Any help would be most welcomed as I am new to all this.

Thank you for your time,
Theo