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: 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:
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