Question Help with Latin special letters ( č ć š đ ž )

U can change collation with this php scrypt.

<?php
// your connection
mysql_connect("localhost","username","password");
mysql_select_db("database_name");

// convert code
$res = mysql_query("SHOW TABLES");
while ($row = mysql_fetch_array($res))
{
foreach ($row as $key => $table)
{
mysql_query("ALTER TABLE " . $table . " CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci");
echo $key . " =&gt; " . $table . " CONVERTED<br />";
}
}
?>

Awesome! Something like that I am searching for a long time. How to use it? Save the code as *.php upload it in ? the joomla root directory? and call it in browser?

You save the code in a php file, and upload it in the root directory of your server, no need to upload it in the joomla directory and call it your browser.

Thanks a lot at both of you. I will try it on test database. I have learned to remember, that I must change the database collation BEFORE I install something to utf8, but it is very helfpul for a lot of users, with wrong collation, if it really works.

for me worked perfectly, if u have any problems post here.

:woohoo: It works! Thanks , karma up!