UTF8 in e-mail problem (2.2.10)

Started by Mystery, November 06, 2018, 09:51:38 AM

Previous topic - Next topic

Mystery

Hello, I recompiled server to UNICODE and changed my MySQL DB to UTF8 but when I try to receive some UTF8 mail, it skips all these characters. Can anyone tell me how to diagnostic this behaviour or what needs to be configured more?

My settings:

NetXMS Server Version 2.2.10 Build 9516 (2.2.10) (UNICODE)
NXCP: 4.48.1.14 (AES-256, Blowfish-256, 3DES, AES-128, Blowfish-128)
Built with: g++ (Debian 4.9.2-10) 4.9.2

MySQL:

+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

Thank you.

Victor Kirhenshtein

Hi,

check that server's configuration parameter MailEncoding set to utf8.

Best regards,
Victor

Mystery

Hello, that was the problem. Thanks.

Now I can see the last UTF8 strange problem, in Event Configuration half of UTF8 characters are changed to ? This is weird.
For example:

ěščřžýáíéůú
is changed to:
?š??žýáíéé?ú

Name of containers are ok. Any idea? Thank you.

Victor Kirhenshtein

Hi,

do you have correct data in database?

Best regards,
Victor

Mystery

#4
Hello, probably yes, because when I create new data, it changes half of these characters too.
MySQL DB is set to UTF8.

Container names, object names, event processing policy, etc .... work ok with all UTF8 char set without problem.
Strange.

Can you try to write Č OR Ř to Event configuration, refresh it and see if encoding works?

Mystery

#5
Ok I solved it :-) I have to change also table charset and fields name charset.

Thank you.