My ZCS version 8.7.6_GA_1776.FOSS
Chat zimlet is 8.7.6 @519a2c6
Cyrillic symbols in user names are displayed incorrectly.

DualBoot wrote:Maybe the properties files for your language are missing.
vladsol wrote:DualBoot wrote:Maybe the properties files for your language are missing.
This is not a localisation problem.
But... Something wrong with encodings.
The default OpenChat database schema was created in latin1_swedish_ci, the administrator
MUST convert it to UTF-8
To verify the collation of the database run this command:Code: Select all
# As zimbra
mysql <<\EOF
SELECT `DEFAULT_COLLATION_NAME`
FROM information_schema.SCHEMATA
WHERE SCHEMA_NAME=`chat`;
EOF
If the current collation name is latin1_swedish_ci migrate the tables running this command:Code: Select all
# As zimbra
mysql <<\EOF
ALTER SCHEMA `chat`
DEFAULT CHARACTER SET `utf8`
DEFAULT COLLATE `utf8_general_ci`;
USE `chat`;
ALTER TABLE `USER`
CONVERT TO
CHARACTER SET `utf8`
COLLATE `utf8_general_ci`;
ALTER TABLE `RELATIONSHIP`
CONVERT TO
CHARACTER SET `utf8`
COLLATE `utf8_general_ci`;
ALTER TABLE `EVENTMESSAGE`
CONVERT TO
CHARACTER SET `utf8`
COLLATE `utf8_general_ci`;
EOF
Users browsing this forum: No registered users and 1 guest