Page 1 of 1
Database with UTF8 failure
Posted: Sat Dec 08, 2007 11:34 am
by Sonya
Hello,
while creating database in uft-8 I've got the error:
Couldn't create table: cms_module_templates
The problem is the key 'module_name' which cannot be created. Probably is the key too large???
CREATE TABLE `cms_module_templates` ( `module_name` varchar(200) default NULL, `template_name` varchar(200) default NULL, `content` text, `create_date` datetime default NULL, `modified_date` datetime default NULL, KEY `module_name` (`module_name`,`template_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
When I delete the key, the table can be created.
Sonya
Re: Database with UTF8 failure
Posted: Sat Dec 08, 2007 12:51 pm
by alby
Sonya wrote:
while creating database in uft-8 I've got the error:
Try to lower varchars to 160:
varchar(200)
Alby
Re: Database with UTF8 failure
Posted: Sat Dec 08, 2007 12:55 pm
by Sonya
alby wrote:
Try to lower varchars to 160:
varchar(200)
Alby
In this case I am going to have problems installing additional modules later if the module_name or template_name is larger than 160 characters. Correct?
Re: Database with UTF8 failure
Posted: Sat Dec 08, 2007 1:04 pm
by alby
Sonya wrote:
alby wrote:
Try to lower varchars to 160:
varchar(200)
Alby
In this case I am going to have problems installing additional modules later if the module_name or template_name is larger than 160 characters. Correct?
Yes, but module name or template name larger then 160
Alby