Tiny Tiny RSS: Community

Table collation issues and questions

I’m getting warnings and user notices regarding what I believe is db collation issues and I’d like to solve them. Although I’m lacking db knowledge to do the right steps.

Here are the warnings:

SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xC5\xBBebro...' for column `ttrss`.`ttrss_entries`.`title` at row 1


SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

I’ve taken a look at the table collation and I have 2 types: utf8_general_ci and latin1_swedish_ci. I’m reading in forums that people have switched to utf8mb64 but not all the tables. So I’m confused on how to move forward and remove these warnings.

Thanks for your help.

Tiny Tiny RSS v19.8 (5bb8dad), Debian 10, PHP 7.3.11, mysql 15.1