ENCODING BUG: Mysql in Railway displays broken utf8mb4 characters

mightymanh
PROOP

20 days ago

I am developing app that use MySql 9.4.0 for database. I have been using it for 3 months and it has been fine until very recently around a week ago, Railway displays some accented text brokenly.

I use table TestCategory for demonstration. category_name is column that displays Vietnamese characters.

If I query data using mysql terminal or sequelize in my backend, it gets data properly.

If I fix the third row to correct text in Railway (by editing straight in Railway UI), while Railway displays that row properly, when I query data in mysql terminal, the third row shows broken text.

Checked both encoding for database and table TestCategory, they use DEFAULTCHARACTERSETNAME = utf8mb4 and DEFAULTCOLLATIONNAME = utf8mb4unicode_ci

Solved

1 Replies

khuynh22
PRO

20 days ago

Seeing the same issue


20 days ago

Hi, thank you for the report, this should be fixed now!


18 days ago

!s


Status changed to Solved brody 18 days ago


Loading...