Project

General

Profile

Actions

Evolution #691

closed

Prevent bug related to strange utf8 content

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

Status:
Fermé
Priority:
Normal
Assignee:
Category:
general
Target version:
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 #2

Updated by Simon almost 7 years ago

Pour un full support de mysql : https://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html

Article de référence : https://mathiasbynens.be/notes/mysql-utf8mb4#character-sets

A partir de mysql 5.5 (2010)

Il peut y avoir à l'avenir des problèmes avec les indexes. Voir :

The same goes for index keys. The InnoDB storage engine has a maximum index length of 767 bytes, so for utf8 or utf8mb4 columns, you can index a maximum of 255 or 191 characters, respectively. If you currently have utf8 columns with indexes longer than 191 characters, you will need to index a smaller number of characters when using utf8mb4. (Because of this, I had to change some indexed VARCHAR(255) columns to VARCHAR(191).)

source : https://mathiasbynens.be/notes/mysql-utf8mb4#character-sets

Le fixe ne convertit pas les tables existantes. Il créer les nouvelles BDD dans ce format.

Actions #3

Updated by Simon almost 7 years ago

  • Status changed from Nouveau to Fermé
  • % Done changed from 0 to 100

Applied in changeset linea21|r3153.

Actions

Also available in: Atom PDF