5000 commenting on a line with accented chars #4911

New Issue

GiteaMirror · 2025-11-02T06:06:57-06:00

GiteaMirror commented

2025-11-02 06:06:57 -06:00

Originally created by @rlogiacco on GitHub (Feb 21, 2020).

Gitea version (or commit ref): 1.11.1
Git version:
Operating system: linux
Database (use [x]):
- PostgreSQL
- MySQL
- MSSQL
- SQLite
Can you reproduce the bug at https://try.gitea.io:
- Yes (provide example URL)
- No
- Not relevant
Log gist:

Description

Commenting on a pull request on a line containing accented characters produces a 500 error with the following log:

2020/02/21 10:48:46 .../repo/pull_review.go:48:CreateCodeComment() [E] CreateCodeComment: Error 1366: Incorrect string value: '\xE8 vali...' for column 'patch' at row 1

The line this comment was pointing at is

			throw new Exception("ATTENZIONE: La Sessione HTTP non è valida");

Originally created by @rlogiacco on GitHub (Feb 21, 2020).   - Gitea version (or commit ref): *1.11.1* - Git version: - Operating system: *linux* - Database (use `[x]`): - [ ] PostgreSQL - [x] MySQL - [ ] MSSQL - [ ] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [x] No - [ ] Not relevant - Log gist: ## Description Commenting on a pull request on a line containing accented characters produces a 500 error with the following log: ``` 2020/02/21 10:48:46 .../repo/pull_review.go:48:CreateCodeComment() [E] CreateCodeComment: Error 1366: Incorrect string value: '\xE8 vali...' for column 'patch' at row 1 ``` The line this comment was pointing at is ``` throw new Exception("ATTENZIONE: La Sessione HTTP non è valida"); ```

GiteaMirror added the issue/duplicate label 2025-11-02 06:06:57 -06:00

GiteaMirror closed this issue

2025-11-02 06:06:58 -06:00

GiteaMirror commented

2025-11-02 06:06:58 -06:00

@lunny commented on GitHub (Feb 21, 2020):

Maybe you should use utf8mb4 charset on your app.ini

@lunny commented on GitHub (Feb 21, 2020): Maybe you should use utf8mb4 charset on your app.ini

GiteaMirror commented

2025-11-02 06:06:59 -06:00

@guillep2k commented on GitHub (Feb 21, 2020):

This happens when the file itself is not using utf-8 (e.g. ISO-8859-1).
This is a duplicate of #7270.