Project

General

Profile

Actions
Copy link

Evolution #691

closed

Prevent bug related to strange utf8 content

Added by Simon over 7 years ago. Updated over 7 years ago.

Status:
Fermé
Priority:
Normal
Assignee:
Simon
Category:
general
Target version:
2.1
Start date:
05/05/2017
Due date:
% Done:

100%

Estimated time:
4.00 h
Resolution:

Description

Here a sample of content :

Echec de la requête SQL<br />[<em> error n° 1366 : Incorrect string value: '\xF0\x9F\x8C\x9E, ...' for column 'workcom_body' at row 1</em> ]<br />

SQL query : INSERT INTO l21_workshop_com (workcom_subject, workcom_body, workcom_parent, workcom_user_id, workcom_workshop_id, workcom_statut, workcom_date_crea, workcom_last_modify ) VALUES('Enercoop', '<p>à tout hasard, pour ceux qui ne connaissent pas :</p>\r\n\r\n<p><a href=\"http://www.enercoop.fr\">http://www.enercoop.fr</a></p>\r\n\r\n<p>et leur dernière lettre d\'infos</p>\r\n\r\n<p><a href=\"https://trailer.web-view.net/Show/0XD29525F88F47940C1F0E9A896CE243058C9E31BC40C1040B5D8CC2141CCB347E16F95EB13E48CCAB.htm\">https://trailer.web-view.net/Show/0XD29525F88F47940C1F0E9A896CE243058C9E31BC40C1040B5D8CC2141CCB347E16F95EB13E48CCAB.htm</a></p>\r\n\r\n<p>🌞, Michel</p>\r\n', 0, 35, 7, 'P', NOW(), NOW());<br />
[Fri 05/May/17 17:35:49]<bFri, 05 May 2017 17:35:49 +0200 />

running script :/public/index.php?post-title=Enercoop&post-body=<p>Ã  tout hasard, pour ceux qui ne connaissent pas :</p>

<p><a href="http://www.enercoop.fr">http://www.enercoop.fr</a></p>

<p>et leur dernière lettre d'infos</p>

<p><a href="https://trailer.web-view.net/Show/0XD29525F88F47940C1F0E9A896CE243058C9E31BC40C1040B5D8CC2141CCB347E16F95EB13E48CCAB.htm">https://trailer.web-view.net/Show/0XD29525F88F47940C1F0E9A896CE243058C9E31BC40C1040B5D8CC2141CCB347E16F95EB13E48CCAB.htm</a></p>
Actions
Copy link

Also available in: Atom PDF