You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by "Yakovlev N." <ya...@krvostok.ru> on 2016/10/24 06:02:03 UTC

Cyrillic encoding Openmeetings 3.1.3 

Hi,

Openmeetings 3.1.3 has been installed on Centos 7.
MariaDB was created by command - DB has been recreated with "CREATE DATABASE
openmeetings DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci".
LANG="ru_RU.UTF-8" is used as locale on Centos 7.
All records in MariaDB have symbols ???????? instead of russian ones.
If I change the records in DB directly (manually) all russian DB-fields look
in OM web interface correctly.
I think something is wrong by recording data into MariaDB.
Where?
Whether anybody knows where is problem?

Thanks.

Regards
Nikolay

RE: Cyrillic encoding Openmeetings 3.1.3

Posted by Maxim Solodovnik <so...@gmail.com>.
Good to know you have solved it.
And thanks for posting solution, might help others :)

Seems to be Maria DB specific setting

WBR, Maxim
(from mobile, sorry for the typos)

On Oct 25, 2016 19:56, "Yakovlev N." <ya...@krvostok.ru> wrote:

> Many thanks to all for the help J
>
>
>
> This issue fixed.
>
> Solution:
>
>
>
> Before creating local DB change the /etc/my.cnf.d/server.cnf file:
>
>
>
> [mysqld]
>
> ...
>
> skip-character-set-client-handshake
>
> collation-server=utf8_unicode_ci
>
> character-set-server=utf8
>
>
>
> Then ... create the local DB:
>
> CREATE DATABASE om313 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
>
>
>
> That's all.
>
>
>
> *From:* Yakovlev N. [mailto:yakovlev_nd@krvostok.ru]
> *Sent:* Monday, October 24, 2016 9:02 AM
> *To:* user@openmeetings.apache.org
> *Subject:* Cyrillic encoding Openmeetings 3.1.3
>
>
>
> Hi,
>
> Openmeetings 3.1.3 has been installed on Centos 7.
> MariaDB was created by command - DB has been recreated with "CREATE
> DATABASE openmeetings DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci".
> LANG="ru_RU.UTF-8" is used as locale on Centos 7.
> All records in MariaDB have symbols ???????? instead of russian ones.
> If I change the records in DB directly (manually) all russian DB-fields
> look in OM web interface correctly.
> I think something is wrong by recording data into MariaDB.
> Where?
> Whether anybody knows where is problem?
>
> Thanks.
>
> Regards
> Nikolay
>
>
>

RE: Cyrillic encoding Openmeetings 3.1.3

Posted by "Yakovlev N." <ya...@krvostok.ru>.
Many thanks to all for the help J

 

This issue fixed.

Solution:

 

Before creating local DB change the /etc/my.cnf.d/server.cnf file:

 

[mysqld]

...

skip-character-set-client-handshake

collation-server=utf8_unicode_ci

character-set-server=utf8

 

Then ... create the local DB:

CREATE DATABASE om313 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

 

That's all.

 

From: Yakovlev N. [mailto:yakovlev_nd@krvostok.ru] 
Sent: Monday, October 24, 2016 9:02 AM
To: user@openmeetings.apache.org
Subject: Cyrillic encoding Openmeetings 3.1.3 

 

Hi,

Openmeetings 3.1.3 has been installed on Centos 7.
MariaDB was created by command - DB has been recreated with "CREATE DATABASE
openmeetings DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci".
LANG="ru_RU.UTF-8" is used as locale on Centos 7.
All records in MariaDB have symbols ???????? instead of russian ones.
If I change the records in DB directly (manually) all russian DB-fields look
in OM web interface correctly.
I think something is wrong by recording data into MariaDB.
Where?
Whether anybody knows where is problem?

Thanks.

Regards
Nikolay