Re: How do I change the character encoding?
Posted by: Apple Jackson
Date: March 14, 2010 12:53PM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How do I change the character encoding?
5056
March 14, 2010 12:53PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.