Investigate charset issue with database #13

New Issue

decentral1se · 2020-07-21T20:27:00Z

decentral1se commented

2020-07-21 20:27:00 +00:00

If you post an emoji or sometimes an image, the database explodes...

gunnarm commented

2020-07-22 10:20:06 +00:00

Have we checked what collation we are using for the database?

🎉 1

decentral1se commented

2020-09-09 05:13:33 +00:00

OK, confirmed on charset/collation!

MariaDB [gitea]> SELECT SCHEMA_NAME 'database', default_character_set_name 'charset', DEFAULT_COLLATION_NAME 'collation' FROM information_schema.SCHEMATA;
+--------------------+---------+-------------------+
| database           | charset | collation         |
+--------------------+---------+-------------------+
| information_schema | utf8    | utf8_general_ci   |
| gitea              | latin1  | latin1_swedish_ci |
| mysql              | latin1  | latin1_swedish_ci |
| performance_schema | utf8    | utf8_general_ci   |
+--------------------+---------+-------------------+
4 rows in set (0.002 sec)

decentral1se commented

2020-09-09 05:14:45 +00:00

Annndddd, it works! 🎉 🎉 🎉

Annndddd, it works! :tada: :tada: :tada:

decentral1se commented

2020-09-09 05:14:59 +00:00

ALTER DATABASE gitea CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

`ALTER DATABASE gitea CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;`

decentral1se closed this issue

2020-09-09 05:14:59 +00:00

3wordchant commented

2020-09-25 19:45:00 +00:00

Emojis still give me a 500 sadly :/ Also gitea crashes and doesn't trigger drone if you use an emoji in the first line of a commit message in a repo with a webhook. Regretfully reopening.

3wordchant reopened this issue

2020-09-25 19:45:00 +00:00

3wordchant self-assigned this 2020-09-25 19:45:13 +00:00

decentral1se self-assigned this 2020-09-27 05:34:44 +00:00

decentral1se commented

2020-09-27 05:52:01 +00:00

🕴️

decentral1se commented

2020-09-27 05:53:21 +00:00

8f78bd6862

I also had to run https://docs.gitea.io/en-us/command-line/#convert.

I will push a commit with an emoji now just to test again.

https://git.autonomic.zone/autonomic-cooperative/git.autonomic.zone/commit/8f78bd6862b82a54c21497f47d9df06abc4e6b21 I also had to run https://docs.gitea.io/en-us/command-line/#convert. I will push a commit with an emoji now just to test again.

❤️ 1

decentral1se commented

2020-09-27 05:54:53 +00:00

943958846a

https://git.autonomic.zone/autonomic-cooperative/git.autonomic.zone/commit/943958846ada367b5b52844445ecc6b2699bb3de

decentral1se closed this issue

2020-09-27 05:54:53 +00:00

This repo is archived. You cannot comment on issues.