Non-latin symbols in user name shows incorrectly
Non-latin symbols in user name shows incorrectly
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.
My ZCS version 8.7.6_GA_1776.FOSS
Chat zimlet is 8.7.6 @519a2c6
Cyrillic symbols in user names are displayed incorrectly.
Re: Non-latin symbols in user name shows incorrectly
Any suggestions?
Re: Non-latin symbols in user name shows incorrectly
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.
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.
Re: Non-latin symbols in user name shows incorrectly
Removed zimbra-chat-1.0.2-1zimbra8.7b1.r7.x86_64 using yum.
Returned to original Zextras chat, there are no problems with it.
Returned to original Zextras chat, there are no problems with it.
- DualBoot
- 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
Maybe the properties files for your language are missing.
Re: Non-latin symbols in user name shows incorrectly
This is not a localisation problem.DualBoot wrote:Maybe the properties files for your language are missing.
But... Something wrong with encodings.
In any case, the original chat (from Zextras) works great.
- jorgedlcruz
- Zimbra Alumni
- Posts: 2782
- Joined: Thu May 22, 2014 4:47 pm
Re: Non-latin symbols in user name shows incorrectly
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
Best regards
Re: Non-latin symbols in user name shows incorrectly
Hi vladsol, You are right
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):
bud
The ZeXtras team
Unfortunately the default database encoding was set as `latin1_swedish_ci` instead of the Zimbra Deafult `utf8_general_ci`vladsol wrote:This is not a localisation problem.DualBoot wrote:Maybe the properties files for your language are missing.
But... Something wrong with encodings.
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):
Have a nice day,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:If the current collation name is latin1_swedish_ci migrate the tables running this command:Code: Select all
# As zimbra mysql <<\EOF SELECT `DEFAULT_COLLATION_NAME` FROM information_schema.SCHEMATA WHERE SCHEMA_NAME=`chat`; EOF
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
bud
The ZeXtras team
Re: Non-latin symbols in user name shows incorrectly
Thanks This helps me as well. Why don't Zimbra creates the Schema in UTF8 format?
Re: Non-latin symbols in user name shows incorrectly
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?