Non-latin symbols in user name shows incorrectly

All around Zimbra Chat, give us your feedback, questions and ideas
vladsol
Posts: 6
Joined: Thu Apr 06, 2017 1:00 pm

Non-latin symbols in user name shows incorrectly

Postby vladsol » Thu Apr 06, 2017 1:12 pm

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.

Image


vladsol
Posts: 6
Joined: Thu Apr 06, 2017 1:00 pm

Re: Non-latin symbols in user name shows incorrectly

Postby vladsol » Mon Apr 10, 2017 10:15 am

Any suggestions? :)
vladsol
Posts: 6
Joined: Thu Apr 06, 2017 1:00 pm

Re: Non-latin symbols in user name shows incorrectly

Postby vladsol » Fri Apr 14, 2017 5:08 am

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.

Image
vladsol
Posts: 6
Joined: Thu Apr 06, 2017 1:00 pm

Re: Non-latin symbols in user name shows incorrectly

Postby vladsol » Fri Apr 14, 2017 9:16 am

Removed zimbra-chat-1.0.2-1zimbra8.7b1.r7.x86_64 using yum.
Returned to original Zextras chat, there are no problems with it.
User avatar
DualBoot
Outstanding Member
Outstanding Member
Posts: 659
Joined: Mon Apr 18, 2016 8:18 pm
Location: Earth
ZCS/ZD Version: ZCS FLOSS - 8.7.11 Mutli servers

Re: Non-latin symbols in user name shows incorrectly

Postby DualBoot » Fri Apr 14, 2017 10:02 am

Maybe the properties files for your language are missing.
vladsol
Posts: 6
Joined: Thu Apr 06, 2017 1:00 pm

Re: Non-latin symbols in user name shows incorrectly

Postby vladsol » Fri Apr 14, 2017 6:59 pm

DualBoot wrote: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.
User avatar
jorgedlcruz
Zimbra Employee
Zimbra Employee
Posts: 2625
Joined: Thu May 22, 2014 4:47 pm

Re: Non-latin symbols in user name shows incorrectly

Postby jorgedlcruz » Fri Apr 14, 2017 11:50 pm

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
Jorge de la Cruz https://jorgedelacruz.es
Technical Marketing Manager at Zimbra/Synacor https://www.zimbra.com/
User avatar
bud
Posts: 16
Joined: Sat Sep 13, 2014 2:38 am
Location: ZeXtras
Contact:

Re: Non-latin symbols in user name shows incorrectly

Postby bud » Thu May 11, 2017 10:36 am

Hi vladsol, You are right
vladsol wrote:
DualBoot wrote: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.

:o 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
Posts: 36
Joined: Sat Sep 13, 2014 3:21 am

Re: Non-latin symbols in user name shows incorrectly

Postby thameera » Tue Jun 06, 2017 6:47 am

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

Return to “Zimbra Chat”

Who is online

Users browsing this forum: No registered users and 1 guest