Page 1 of 1

Text cut off at UTF Emoticons

Posted: 08 Dec 2013, 13:11
by 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: 💗

Re: Text cut off at UTF Emoticons

Posted: 08 Dec 2013, 13:27
by ldidry
I saw a little heart in your message body in TTRSS. Maybe your database encoding isn't correct?

Re: Text cut off at UTF Emoticons

Posted: 08 Dec 2013, 13:30
by fox
Image

Seems to work fine here, I dunno.

Re: Text cut off at UTF Emoticons

Posted: 08 Dec 2013, 13:37
by HeikoAdams
Got the same problem. Database encoding is utf8_general_ci

Re: Text cut off at UTF Emoticons

Posted: 08 Dec 2013, 14:32
by 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?

Re: Text cut off at UTF Emoticons

Posted: 08 Dec 2013, 16:24
by hrk
http://yoonkit.blogspot.it/2006/03/mysq ... -utf8.html

This should work.

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

Re: Text cut off at UTF Emoticons

Posted: 08 Dec 2013, 16:46
by fox
This is old and can fuck up your database real bad.

Re: Text cut off at UTF Emoticons

Posted: 09 Dec 2013, 00:27
by 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?