Re: unicode - Arabic - data restore problem

[Ted Harper]

My php application is using "charset=utf-8"

Here's how my create table looks like:

CREATE TABLE `articlecomments` (
`id` int(10) NOT NULL auto_increment,
`articleid` int(10) NOT NULL default '0',
`author` varchar(50) character set latin1 collate latin1_general_ci default NULL,
`email` varchar(50) character set latin1 collate latin1_general_ci default NULL,
`createdate` datetime default NULL,
`title` varchar(100) character set latin1 collate latin1_general_ci NOT NULL default '',
`comment` text character set latin1 collate latin1_general_ci NOT NULL,
`status` int(1) NOT NULL default '0',
`country` varchar(30) character set latin1 collate latin1_general_ci NOT NULL default '',
`ip` varchar(20) character set latin1 collate latin1_general_ci default NULL,
`host` varchar(50) character set cp1256 default NULL,
`countrycode` char(2) character set cp1256 default NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=532 ;

--
-- Dumping data for table `articlecomments`
--



Edited 1 time(s). Last edit at 07/24/2006 12:06AM by Ted Harper.