Text cut off at UTF Emoticons

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
reibuehl
Bear Rating Trainee
Bear Rating Trainee
Posts: 25
Joined: 17 May 2013, 19:37

Text cut off at UTF Emoticons

Postby reibuehl » 08 Dec 2013, 13:11

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
Bear Rating Trainee
Bear Rating Trainee
Posts: 27
Joined: 11 Jun 2013, 20:43

Re: Text cut off at UTF Emoticons

Postby ldidry » 08 Dec 2013, 13:27

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

User avatar
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

Postby fox » 08 Dec 2013, 13:30

Image

Seems to work fine here, I dunno.

User avatar
HeikoAdams
Bear Rating Master
Bear Rating Master
Posts: 101
Joined: 19 Mar 2013, 00:17

Re: Text cut off at UTF Emoticons

Postby HeikoAdams » 08 Dec 2013, 13:37

Got the same problem. Database encoding is utf8_general_ci

reibuehl
Bear Rating Trainee
Bear Rating Trainee
Posts: 25
Joined: 17 May 2013, 19:37

Re: Text cut off at UTF Emoticons

Postby reibuehl » 08 Dec 2013, 14:32

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
Bear Rating Disaster
Bear Rating Disaster
Posts: 75
Joined: 24 Apr 2013, 12:39

Re: Text cut off at UTF Emoticons

Postby hrk » 08 Dec 2013, 16:24

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

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.

User avatar
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

Postby fox » 08 Dec 2013, 16:46

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

reibuehl
Bear Rating Trainee
Bear Rating Trainee
Posts: 25
Joined: 17 May 2013, 19:37

Re: Text cut off at UTF Emoticons

Postby reibuehl » 09 Dec 2013, 00:27

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?


Return to “Support”

Who is online

Users browsing this forum: No registered users and 8 guests