Re: unicode - Arabic - data restore problem
Posted by: Ted Harper
Date: July 21, 2006 06:19PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: unicode - Arabic - data restore problem
6148
July 21, 2006 06:19PM


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.