phpmyadmin import issue

[niziptv]

I am using phpmyadmin to import some Turkish data to my joomla. The database is in utf-8 charset which is default, and tables are in latin1_sweedish collation which is default as well.

whenever I import some data to joomla the data in turkish chars are seen weird as ? chars.

How can I fix this? I have seen some posts regarding changing MySQL db charset, but I could not find such an option in control panel.

[kenny]

Please try exporting the database by setting the Compatibility option to MySQL40. There is a known issue with non-latin1 characters and MySQL 4.1.

A good way to check whether the dump is good or not is to upload it on your account and open it in a browser. Change the Character Encoding to the one the file uses -- you should be able to see all characters correctly.

[niziptv]

There is a serious issue with Fantastico. During the creation of Joomla websites, it does not ask you the charset for the DB and Joomla!

[kenny]

If you are transferring a Joomla installation from another server, you should not use Fantastico. You need to upload your files, import your database (with the proper encoding, and create the tables with the proper charset/collation), and then re-configure Joomla to use the local paths, URLs and database credentials.

This link may be helpful:

http://www.siteground.com/tutorials/joomla/joomla_manual_installation.htm

[niziptv]

I am not migrating from another site. I just want to know whether I could select charset for MySQL and Joomla during the automated creation of Joomla site via Fantastico. is this possible in Fantastico?

[kenny]

No, I am afraid Fantastico does not support customizing the charset of the installation. You will have to go for the manual install.

[niziptv]

That's a shame for Fantastico!