• Dear Pleskians! The Plesk Forum will be undergoing scheduled maintenance on Monday, 7th of July, at 9:00 AM UTC. The expected maintenance window is 2 hours.
    Thank you in advance for your patience and understanding on the matter.

Sitebuilder character set

testt

New Pleskian
Hello,

It seems that in our sitebuilder, even though the tables are set to utf8_general_ci, when setting the interface to Chinese/Taiwanese, Sitebuilder doesn't want to display those characters.

sitebuilder1.JPG


Does anyone know of any collation changes/database changes I need to make to correct this? Thanks.
 
nope

I went through and confirmed that all the of databases are currently set to utf-8 but we are still seeing the question marks. Do you know what else it could be?
 
mysql> show create database sitebuilder;
+-------------+----------------------------------------------------------------------+
| Database | Create Database |
+-------------+----------------------------------------------------------------------+
| sitebuilder | CREATE DATABASE `sitebuilder` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+-------------+----------------------------------------------------------------------+
1 row in set (0.00 sec)

and

mysql> show create table site_page;
+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| site_page | CREATE TABLE `site_page` (
`id` int(11) NOT NULL auto_increment,
`order_id` int(11) NOT NULL default '0',
`parent_id` int(11) NOT NULL default '0',
`site_page_type_id` int(11) NOT NULL default '0',
`module_id` varchar(255) default NULL,
`title` varchar(255) NOT NULL default '',
`content` longtext NOT NULL,
`is_visible` int(1) NOT NULL default '1',
`keywords` text NOT NULL,
`description` text NOT NULL,
`file_name` varchar(255) default '',
`identity` varchar(255) default '',
`is_plain` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `order_id` (`order_id`),
KEY `parent_id` (`parent_id`),
KEY `module_id` (`module_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2142675 DEFAULT CHARSET=utf8 |
+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

We already have the db and the tables created in UTF8.

The mysql charset is also UTF8.

[root@sitestudio ~]# mysqladmin variables |grep char
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |

So it not a UTF issue in this case. We are replying to the forum thread and will see what they come up with.
 
Back
Top