Hello,

I am having a problem with importing a phpbb forum database to another website - all the posts were used as utf-8 to display non-english characters; however, when I looked at the database structure in mysql, all the tables listing "latin1_swedish_ci" The old database wasn't setup with utf-8 correctly.

When I used the older version of mysql- 4.0.x, I did not see any column heading named "collation", and I had no problem with importing/exporting database.

I have 2 questions and hope you can give me some advices:

1-if the text should be using utf-8; what should I do to setup utf-8 correctly in the database. Right now, I see there are several dropdown list menu if I click on "localhost" on the breadcrum menu: 1)Language 2)MySQL charset, and 3) MySQL connection collation.

2-with the old database I am trying to import to another database, all the tables having collation of "latin1_swedish_ci", how could I convert it to "utf-8"?

Many Thanks!

just wanted to update:
I have fixed the problem by making sure the new database is set with utf. For the old database, before exporting it, I have to set it to utf as well, also, I need to go into each tables and columns and change it to utf.