Non-latin symbols in user name shows incorrectly

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

Non-latin symbols in user name shows incorrectly

Post by 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.

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

Re: Non-latin symbols in user name shows incorrectly

Post by vladsol »

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

Re: Non-latin symbols in user name shows incorrectly

Post by 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.

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

Re: Non-latin symbols in user name shows incorrectly

Post by 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.
User avatar
DualBoot
Elite member
Elite member
Posts: 1326
Joined: Mon Apr 18, 2016 8:18 pm
Location: France - Earth
ZCS/ZD Version: ZCS FLOSS - 8.8.15 Mutli servers
Contact:

Re: Non-latin symbols in user name shows incorrectly

Post by DualBoot »

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

Re: Non-latin symbols in user name shows incorrectly

Post by vladsol »

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 Alumni
Zimbra Alumni
Posts: 2782
Joined: Thu May 22, 2014 4:47 pm

Re: Non-latin symbols in user name shows incorrectly

Post by 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
Jorge de la Cruz https://jorgedelacruz.es
Systems Engineer at Veeam Software https://www.veeam.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

Post by bud »

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

Re: Non-latin symbols in user name shows incorrectly

Post by thameera »

Thanks This helps me as well. Why don't Zimbra creates the Schema in UTF8 format?
dreyev
Posts: 1
Joined: Tue Oct 17, 2017 1:29 pm

Re: Non-latin symbols in user name shows incorrectly

Post by dreyev »

I have installed Zimbra 8.7.11 - there is a problem with displaying names in the Chat, names are not in Latin, but in Cyrillic. What to do, tell me?
Post Reply