graulund / tweetnest

NO LONGER MAINTAINED. MESSAGE ME IF YOU WANT TO MAINTAIN THIS. :) A browsable, searchable and easily customizable archive and backup for your tweets
MIT License
492 stars 93 forks source link

Empty tweets when Emojis are used as first character #76

Closed pixelbrackets closed 9 years ago

pixelbrackets commented 9 years ago

If an Emoji is used in a tweet and it is is the leading character, then the whole field will be empty. Tweetnest will then show an empty tweet.

If Emojis are placed somewhere else, they are removed and the text is cropped from this point on.

pixelbrackets commented 9 years ago

Emojis are UTF8MB4 characters. A MySQL database with a charset like »utf8_unicode_ci« is not able to store these characters correctly. Solution: