Joomla Templates Club 406,261 posts

[persianwebs Developer persianwebsJoin date: February 2015Posts: 92Downloads:0Uploads:11 Thanks: 11]

#206662

I’ve installed the Bookshop theme, installed the Persian language pack, and changed the collation of my DB to
utf8_general_ci, but still when I try to type new content in the website and save it shows as ???

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#571938

Hi there
Have you checked your table & fields charset ?

Thank you,
Viet Vu

[persianwebs Developer persianwebsJoin date: February 2015Posts: 92Downloads:0Uploads:11 Thanks: 11]

#572063

My collation is utf_general_ci, but I’m not
Sure how to check my charset

[persianwebs Developer persianwebsJoin date: February 2015Posts: 92Downloads:0Uploads:11 Thanks: 11]

#737103

My collation is utf_general_ci, but I’m not
Sure how to check my charset

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#572064

Hi there
Please check into fields which one stored your data via phpmyadmin.

Thank you,
Viet Vu

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#737104

Hi there
Please check into fields which one stored your data via phpmyadmin.

Thank you,
Viet Vu

[persianwebs Developer persianwebsJoin date: February 2015Posts: 92Downloads:0Uploads:11 Thanks: 11]

#572140

I am sorry, but I didn’t understand what you meant by your last post.
I checked all the table collations and the collation is right.
Can I private message DB login for you to check?

[persianwebs Developer persianwebsJoin date: February 2015Posts: 92Downloads:0Uploads:11 Thanks: 11]

#572144

<em>@jooservices 475359 wrote:</em><blockquote>Hi there
Please check into fields which one stored your data via phpmyadmin.

Thank you,
Viet Vu</blockquote>

I was able to fix it with running a script

<?php
$con = mysql_connect('localhost','user','password');
if(!$con) { echo "Cannot connect to the database ";die();}
mysql_select_db('dbname');
$result=mysql_query('show tables');
while($tables = mysql_fetch_array($result)) {
foreach ($tables as $key => $value) {
mysql_query("ALTER TABLE $value CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci");
}}
echo "The collation of your database has been successfully changed!";
?>

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#572170

Glad to hear that.

Thank you,
Viet Vu

[Author]

Posts