search

Needlworks / Textcube

Textcube : Brand yourself! / Personalized web publishing platform with multi-user support
http://www.textcube.org
Other
209 stars 55 forks source link

Inserting unicode emoji in article and saving removes all html content after the character #1840

Closed zvuc closed 8 years ago

zvuc commented 8 years ago

Reproduce

  1. Write text.
  2. Insert unicode emoji (😂)
  3. Write text after the emoji character.
  4. Save post.
  5. Go into editor again
  6. Text after and including the emoji character is gone.
inureyes commented 8 years ago

I tested and found that emoji is replaced with ????, and contents are still preserved. Tested with Chrome 51 (MacOSX)

inureyes commented 8 years ago

@zvuc I checked and found the reason that broken emoji sujpport is originated from weak support of 4-byte emoji in MySQL. Please change the table collation from utf8 to utf8md4 and it should work fine. :)