Testimonial Manager Support Thread

[guitarmong]

hi, i can't will my chinese code in the testimonials,, do u have any latest version to support UTF-8, i have code converter software but i dun know which files to effect this..

[clydejones]

hi, i can't will my chinese code in the testimonials,, do u have any latest version to support UTF-8, i have code converter software but i dun know which files to effect this..

All of the information for Testimonial Manager is stored in the database table so there are no files to edit.

[guitarmong]

oh my god,, so will u issue a latest version to support UTF-8? i looking forward on this,, thanks!

[clydejones]

oh my god,, so will u issue a latest version to support UTF-8? i looking forward on this,, thanks!

run this sql patch using the Zen-Cart Sql Patches tool (admin -> tools -> install sql patches)

copy and past this code into the text area and click the send button.

DROP TABLE IF EXISTS testimonials_manager;
CREATE TABLE testimonials_manager (
  `testimonials_id` int(11) NOT NULL auto_increment,
  `language_id` int(11) NOT NULL default '0',
  `testimonials_title` varchar(64) NOT NULL default '',
  `testimonials_url`  VARCHAR( 255 ) NULL DEFAULT NULL,
  `testimonials_name` text NOT NULL,
  `testimonials_image` varchar(254) NOT NULL default '',
  `testimonials_html_text` text,
  `testimonials_mail` text NOT NULL,
  `testimonials_company` VARCHAR( 255 ) NULL DEFAULT NULL,
  `testimonials_city` VARCHAR( 255 ) NULL DEFAULT NULL,
  `testimonials_country` VARCHAR( 255 ) NULL DEFAULT NULL,
  `testimonials_show_email` char(1) default '0',
  `status` int(1) NOT NULL default '0',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_update` datetime NULL default NULL,
  PRIMARY KEY  (`testimonials_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;