MySQL converting character sets question.

utf8_general_ci needs to be utf8_polish_ci

[mikesz]

Hello mysql,

Here is the short version of my story. I have a database that was not
correctly defined at creation time and is currently set to utf8_general_ci but the script that is using that database requires Polish character set to display correctly (some of the characters are garbled and the indexing that contains these characters fails. I think the database needs to be utf8_polish_ci.

I was thinking about ways to solve this problem, like exporting the data and recreating the database with the correct collation would solve the problem then I noticed in phpMyAdmin that I could copy the database with a different collation and wondered if that would be another way to get the correct solution.

Any thoughts or comments on the "right" way to convert from
utf8_general_ci to utf8_polish_ci?

Thank you for your attention.

mikesz