Non-latin symbols in user name shows incorrectly

[vladsol]

Hi.

My ZCS version 8.7.6_GA_1776.FOSS
Chat zimlet is 8.7.6 @519a2c6

Cyrillic symbols in user names are displayed incorrectly.

[vladsol]

Any suggestions?

[vladsol]

Ok... It is possible to disable native xmpp? Remove zimbra-chat-1.0.2-1zimbra8.7b1?
I have disabled (and unistalled) zimlet com_zextras_chat_open, but something is still listening port 5222

At now i can't start Zextras Chat service.

[vladsol]

Removed zimbra-chat-1.0.2-1zimbra8.7b1.r7.x86_64 using yum.
Returned to original Zextras chat, there are no problems with it.

[DualBoot]

Maybe the properties files for your language are missing.

[vladsol]

Maybe the properties files for your language are missing.

This is not a localisation problem.
But... Something wrong with encodings.

In any case, the original chat (from Zextras) works great.

[jorgedlcruz]

This is a known issue on Zimbra Chat due to the encoding on the DB, we are working on fixing it and provide a workaround too

Best regards

[bud]

Hi vladsol, You are right

Maybe the properties files for your language are missing.

This is not a localisation problem.
But... Something wrong with encodings.

Unfortunately the default database encoding was set as `latin1_swedish_ci` instead of the Zimbra Deafult `utf8_general_ci`
In new versions (starting from Zimbra 8.7.7) of the OpenChat installation this issue was fixed.

WARNING: Any manual modification of the database schema may lead to an error during a future Zimbra Update!

To migrate manually an older database (if is not already migrated during the Zimbra ugrade) you can type these commands from the admin guide from github page (page 25, section 3.2.1):

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


Have a nice day,
bud
The ZeXtras team

[thameera]

Thanks This helps me as well. Why don't Zimbra creates the Schema in UTF8 format?