hi,

by now i've used mysql 4.0 now i have to switch to 5.0. my problem is that the
old databases are in latin1 and all my php code does not care about character
sets as it just used to work ...

i was able to load the datat to mysql 5.0 with latin1 encoding. aleast mysql
shows latin1 as characterset for my tables. but php connects with UTF-8 and
the default character set i UTF-8 too. i've tried to set the session charset
to latin1 without success.

so here are my questions:

1. is ist possible to switch mysql 5.0 completely to UTF-8 ?

2. an option would be to convert my data from latin1 to UTF-8
how can i do this ?

TIA
matthias