Sitebuilder character set

[testt]

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.

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

 

[IgorG]

Look at following KB article http://kb.odin.com/en/5539
I hope it will help.

 

[testt]

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?

 

[SpencerW]

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.