😢 unicode chars in comments/shoutbox appear as ???? or ? or … on the prod website

[LGD-Fr]

SQL problem ? Everything goes right on the «manage.py» dev server.

[LGD-Fr]

Fixed with:

ALTER DATABASE paiji2 CHARACTER SET = 'utf8' COLLATE = 'utf8_general_ci';

Then, for each table:

ALTER TABLE table CONVERT TO CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

See https://mariadb.com/kb/en/mariadb/setting-character-sets-and-collations/

[luc--]

Thx