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

Popular posts from this blog

javascript - Karma not able to start PhantomJS on Windows - Error: spawn UNKNOWN -

c# - Display ASPX Popup control in RowDeleteing Event (ASPX Gridview) -

Nuget pack csproj using nuspec -