Database character encoding problems.

Hello

I just noticed that my database uses latin1_swedish_ci character set. My html documents use UTF-8 unicode charset.
Is there a way to convert every table in the database to UTF-8 unicode? Will anything happen to the data?

 

If it's not broken don't fix it.

 

you can dump the database and recreate it

mysqldump -B database > Mydatabase.sql
then in sql "drop database mydatabase"
edit Mydatabase.sql and correct problem
mysqladmin create database
mysql database <Mydatabase.sql

 

You can use this to convert tables to utf8 - you'll need MySQL version 4.1+

ALTER TABLE x CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

 

That worked, Thanks.
Although some characters like é, è the copyright symbol, the TM symbol still show up on the webpage as weird black dots with a question mark in it ...