Fixed
Work for version Jot 1.1.4
In file ’
includes/jot.install.db.sql’ you need add "DEFAULT CHARSET=utf8" to every create table statement, and DROP TABLE `
jot_content`, `
jot_fields`, `
jot_subscriptions`.
Or copy-paste this
CREATE TABLE IF NOT EXISTS `{PREFIX}jot_content` (
`id` int(10) NOT NULL auto_increment,
`title` varchar(255) default NULL,
`tagid` varchar(50) default NULL,
`published` int(1) NOT NULL default '0',
`uparent` int(10) NOT NULL,
`parent` int(10) NOT NULL default '0',
`flags` varchar(25) default NULL,
`secip` varchar(32) default NULL,
`sechash` varchar(32) default NULL,
`content` mediumtext,
`mode` int(1) NOT NULL default '1',
`createdby` int(10) NOT NULL default '0',
`createdon` int(20) NOT NULL default '0',
`editedby` int(10) NOT NULL default '0',
`editedon` int(20) NOT NULL default '0',
`deleted` int(1) NOT NULL default '0',
`deletedon` int(20) NOT NULL default '0',
`deletedby` int(10) NOT NULL default '0',
`publishedon` int(20) NOT NULL default '0',
`publishedby` int(10) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `parent` (`parent`),
KEY `secip` (`secip`),
KEY `tagidx` (`tagid`),
KEY `uparent` (`uparent`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `{PREFIX}jot_subscriptions` (
`id` mediumint(10) NOT NULL auto_increment,
`uparent` mediumint(10) NOT NULL,
`tagid` varchar(50) NOT NULL,
`userid` mediumint(10) NOT NULL,
PRIMARY KEY (`id`),
KEY `uparent` (`uparent`),
KEY `tagid` (`tagid`),
KEY `userid` (`userid`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `{PREFIX}jot_fields` (
`id` mediumint(10) NOT NULL,
`label` varchar(50) NOT NULL,
`content` text,
KEY `id` (`id`),
KEY `label` (`label`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
Or if you don`t want reinstall snippet Jot and lost you comments, you can change charset to UTF8 of `jot_content`, `jot_fields`, `jot_subscriptions` tables (and you would must decoding to UTF8 existing comments).
