Re: How do I change the character encoding?
So I change this:
CREATE TABLE IF NOT EXISTS `affiliates` (
`id` int(11) NOT NULL auto_increment,
`owning_user_id` int(11) NOT NULL,
`new_user_id` int(11) NOT NULL,
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `affiliate_FK_1` (`owning_user_id`),
KEY `affiliate_FK_2` (`new_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
to this:
CREATE TABLE IF NOT EXISTS `affiliates` (
`id` int(11) NOT NULL auto_increment,
`owning_user_id` int(11) NOT NULL,
`new_user_id` int(11) NOT NULL,
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_at` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `affiliate_FK_1` (`owning_user_id`),
KEY `affiliate_FK_2` (`new_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
Does that fix the problem?