Project

General

Profile

Actions

Defect #32972

open

UTF8 Symbols as Usernames get Truncated

Added by about 4 years ago. Updated 3 months ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Website (redmine.org)
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Affected version:

Description

i noticed my name was easter egg on this redmine and i wanted it as easteregg but was forced to set a last name, which i choose to set to @

Actions #1

Updated by about 4 years ago

everything in this bugreport got truncated from the first occurence of the utf8 emoji. here is the rest of the report with the unicode symbol replaced with egg

full report:

i noticed my name was easter egg on this redmine and i wanted it as easteregg but was forced to set a last name, which i choose to set to _egg_ which is U+1F95A

more info at: https://www.fileformat.info/info/unicode/char/1f95a/index.htm

this gets completly removed from my name, and when applied to both, i have no clickable username.
if the username string will be truncated it should be checked afterswards, if my name is valid - in this case non-zero length!

for demonstration purposes, i leave my name set to a zero length string :)

i wonder if this might be related to the database backend.
i tested it on my installation with 4.1.0 and a postgresql 12.1 database as backend with the locale set to en_US.UTF-8 and the egg will be printed

Actions #2

Updated by about 4 years ago

the preview funktion works fine btw, this occurs only if its passed through the database, so i suspect it to be databaserelated.

Actions #3

Updated by Daniel Drexlmaier about 2 years ago

Solution: Convert table to utf8mb and set in file database.yml "encoding: utf8mb4"

Actions #4

Updated by Go MAEDA 3 months ago

  • Category changed from Accounts / authentication to Website (redmine.org)
Actions

Also available in: Atom PDF