Text cut off at UTF Emoticons

[reibuehl]

Hi all,

I have some feeds where authors use UTF-8 emoticons like U+1F497 in the title or body of feed items. The RSS feed validates correct when I check it via the w3c validator and shows also correct in Firefox. In TT-RSS however, the title or body is always cut of before the UTF-8 character.
Since the RSS/Atom feed uses UTF-8 as character set in its header, I thought that TT-RSS should correctly handle this, but apparently it doesn't. Do I need to set any special config settings for this to work?

Best regards,
Reiner.

PS: Just in case somebody reads this group via TT-RSS, there should be an U+1F497 character at the end of this line: 💗

[ldidry]

I saw a little heart in your message body in TTRSS. Maybe your database encoding isn't correct?

[fox]

Seems to work fine here, I dunno.

[HeikoAdams]

Got the same problem. Database encoding is utf8_general_ci

[reibuehl]

Okay, glad to hear that it is not a general problem but just a config thing on my side. As it seems to be a database encoding problem on my side, can some one - not Fox, as I still use the "wrong" database - recommend a way how to check and change the settings in Mysql?

[hrk]

http://yoonkit.blogspot.it/2006/03/mysq ... -utf8.html

This should work.

EDIT: and maybe not, as fox recommends against it.

[fox]

This is old and can fuck up your database real bad.

[reibuehl]

I checked the database settings and character set is set to UTF8 in the ttrss settings and in the database the defaults are also set to use UTF-8. I am not sure where to look else. Any ideas?