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.