garbled characters #255

Open
opened 3 months ago 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.
Poster

Thank you for your reply, the sqlite3 database used!

Thank you for your reply, the sqlite3 database used!
tslocum added the
bug
label 3 months ago
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.
Poster

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

well,as : `小腹微微突出,下体还有若隐若现的……`
Sign in to join this conversation.
No Milestone
No Assignees
2 Participants
Notifications
Due Date

No due date set.

Dependencies

This issue currently doesn't have any dependencies.

Loading…
There is no content yet.