Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (Flatly)
  • No Skin
Collapse
Brand Logo

NetXMS Forum

  1. Home
  2. Support
  3. UTF8 in e-mail problem (2.2.10)

UTF8 in e-mail problem (2.2.10)

Scheduled Pinned Locked Moved Support
6 Posts 2 Posters 14.0k Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M
    M
    Mystery
    wrote on last edited by
    #1

    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.

    1 Reply Last reply
    0
    • V
      V
      Victor Kirhenshtein
      wrote on last edited by
      #2

      Hi,

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

      Best regards,
      Victor

      1 Reply Last reply
      0
      • M
        M
        Mystery
        wrote on last edited by
        #3

        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.

        1 Reply Last reply
        0
        • V
          V
          Victor Kirhenshtein
          wrote on last edited by
          #4

          Hi,

          do you have correct data in database?

          Best regards,
          Victor

          1 Reply Last reply
          0
          • M
            M
            Mystery
            wrote on last edited by
            #5

            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?

            1 Reply Last reply
            0
            • M
              M
              Mystery
              wrote on last edited by
              #6

              Ok I solved it 🙂 I have to change also table charset and fields name charset.

              Thank you.

              1 Reply Last reply
              0

              Hello! It looks like you're interested in this conversation, but you don't have an account yet.

              Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

              With your input, this post could be even better 💗

              Register Login
              Reply
              • Reply as topic
              Log in to reply
              • Oldest to Newest
              • Newest to Oldest
              • Most Votes


              • Login

              • Don't have an account? Register

              • Login or register to search.
              Powered by NodeBB Contributors
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • Users
              • Groups