php - Incorrect string value: '\xE8.. &n...' for column -
i'm creating ticket system in php uses imap fetch mail exchange server.
when i'm putting html message email in mysql database, following error occurs when there special char in message body รจ:
incorrect string value: '\xe8. ' column 'message' @ row 1
i allready tried stuff like:
utf8_encode($message);
but removes html message shouldn't happen.
the mysql table:
mysql> show create table crm.tickets; +---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | table | create table | +---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | tickets | create table `tickets` ( `id` int(100) not null auto_increment, `sendername` varchar(40) default null, `senderemail` varchar(60) default null, `companyid` int(15) default null, `userid` int(15) default null, `subject` varchar(100) default null, `message` longtext, `timestamp` int(60) default null, `toname` varchar(120) default null, `toemail` varchar(60) default null, `ownerid` int(11) default null, `ticketstatus` int(1) default null, `tickettype` int(2) default null, `timespend` int(10) default null, `locked` int(1) default null, `queue` int(3) default null, primary key (`id`) ) engine=innodb auto_increment=31 default charset=utf8 | +---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)
anyone got idea?
i created own function replace microsoft chars html chars. working charm!
Comments
Post a Comment