Vote #80678
未完了UTF8 Symbols as Usernames get Truncated
0%
説明
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 @
journals
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_
h1. 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
--------------------------------------------------------------------------------
the preview funktion works fine btw, this occurs only if its passed through the database, so i suspect it to be databaserelated.
--------------------------------------------------------------------------------
Solution: Convert table to utf8mb and set in file database.yml "encoding: utf8mb4"
--------------------------------------------------------------------------------