How to fix Unicode problem in MySQL

[ace]

Hello,
Any one gets problem with Unicode in MySQL 4.1? My database runs well with MySQL 4.0, but after upgrading to MySQL 4.1 that all the data (text and varchar) with Unicode charset have been converted to symbols: ???? and why this SQL version is always happening a "Collation" column in my db? Do you know how to fix this Unicode problem between MySQL 4.0 and MySQL 4.1?

[jpetrov]

i have few sites (mambo) and all went ok. are you sure you have mysql set up?

[PvUtrix]

it's not a problem, it's a new feature of MySQL 4.1 all databases, tables and columns have encoding assigned to them.
Default is UTF8, check the MySQL documentation for tips on migrating