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: 💗
Text cut off at UTF Emoticons
Re: Text cut off at UTF Emoticons
I saw a little heart in your message body in TTRSS. Maybe your database encoding isn't correct?
- fox
- ^ me reading your posts ^
- Posts: 6318
- Joined: 27 Aug 2005, 22:53
- Location: Saint-Petersburg, Russia
- Contact:
Re: Text cut off at UTF Emoticons

Seems to work fine here, I dunno.
- HeikoAdams
- Bear Rating Master
- Posts: 101
- Joined: 19 Mar 2013, 00:17
Re: Text cut off at UTF Emoticons
Got the same problem. Database encoding is utf8_general_ci
Re: Text cut off at UTF Emoticons
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
http://yoonkit.blogspot.it/2006/03/mysq ... -utf8.html
This should work.
EDIT: and maybe not, as fox recommends against it.
This should work.
EDIT: and maybe not, as fox recommends against it.

Last edited by hrk on 08 Dec 2013, 17:13, edited 1 time in total.
- fox
- ^ me reading your posts ^
- Posts: 6318
- Joined: 27 Aug 2005, 22:53
- Location: Saint-Petersburg, Russia
- Contact:
Re: Text cut off at UTF Emoticons
This is old and can fuck up your database real bad.
Re: Text cut off at UTF Emoticons
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?
Who is online
Users browsing this forum: No registered users and 10 guests