garbled characters #255

Closed
opened 2022-05-20 08:17:14 +00:00 by jaolllddd · 4 comments

Hello, Chinese characters are garbled!iShot_2022-05-20_16.16.31.png

How to delete pictures when deleting content?

Hello, Chinese characters are garbled!![iShot_2022-05-20_16.16.31.png](https://s2.loli.net/2022/05/20/PIkQKtDrJqNelad.png) How to delete pictures when deleting content?
Owner

Hi, if you installed TinyIB before this commit and you are using the MySQL database mode, you may need to change the charset for each field in the database used by TinyIB from utf8 to utf8mb4, and from collation utf8_unicode_citoutf8mb4_unicode_ci`. Then the characters may be stored in the database correctly.

Let me know if that fixes things for you.

Hi, if you installed TinyIB before [this commit](https://code.rocketnine.space/tslocum/tinyib/commit/dbe4e1ec293b45e85a6d5200add414618136bca4) and you are using the MySQL database mode, you may need to change the charset for each field in the database used by TinyIB from `utf8` to utf8mb4`, and from collation `utf8_unicode_ci` to `utf8mb4_unicode_ci`. Then the characters may be stored in the database correctly. Let me know if that fixes things for you.
Author

Thank you for your reply, the sqlite3 database used!

Thank you for your reply, the sqlite3 database used!
tslocum added the
bug
label 2022-05-25 19:23:35 +00:00
Owner

Please share some example text (as it appears normally) that causes this, so I can reproduce this issue on my server.

Please share some example text (as it appears normally) that causes this, so I can reproduce this issue on my server.
Author

well,as : 小腹微微突出,下体还有若隐若现的……

well,as : `小腹微微突出,下体还有若隐若现的……`
Sign in to join this conversation.
No Milestone
No Assignees
2 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: tslocum/tinyib#255
No description provided.