Project

General

Profile

Actions

Defect #32972

open

UTF8 Symbols as Usernames get Truncated

Defect #32972: UTF8 Symbols as Usernames get Truncated

Added by almost 7 years ago. Updated almost 3 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Website (redmine.org)
Target version:
-
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 @

Updated by almost 7 years ago Actions #1

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

Updated by almost 7 years ago Actions #2

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

Updated by Daniel Drexlmaier almost 5 years ago Actions #3

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

Updated by Go MAEDA almost 3 years ago Actions #4

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

Also available in: PDF Atom