Support » Plugin: Newsletter » Cant save UNICCODE at List Build Editor

  • Resolved manfredman

    (@manfredman)


    When I use UNICODE in List Build Editor, I cannot save the page created in the editor.
    Unicode are small symbols that are cryptically encoded in ASCII.
    https://emojipedia.org/unicode-13.0
    Example for UNICODE: 🐛

    With greetings
    Manfred Reichenbach

    • This topic was modified 6 months ago by manfredman.
    • This topic was modified 6 months ago by manfredman.

    The page I need help with: [log in to see the link]

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author Stefano Lissa

    (@satollo)

    Hi Newsletter worsk with utf-8mb4 correctly, but maybe your database is not utf8mb4. Check on newsletter status panel if something is reported about that.

    manfredman

    (@manfredman)

    Hy Stefano,
    I have tested UTF-8 and it is correct.
    UTF-8 works.
    That was not my question ..
    My question was about Unicode 8 and higher.
    And there litle different between UTF and UNICODE.
    Look here:
    https://stackoverflow.com/questions/643694/what-is-the-difference-between-utf-8-and-unicode
    Unicode 1.1 is work.. but not higher..
    That will not do ..
    Ok can live with that.

    • This reply was modified 6 months ago by manfredman.
    Plugin Author Stefano Lissa

    (@satollo)

    UTF-8 is a method to encode with a byte sequence the unicode characters (even for the different unicode plans).
    If you have a mysql with table in utf-8, it is able to store max 3 byte sequence and so every emoji is dropped. You need to be sure the encoding of the tables and fields is utf8mb4 at database level to store the emoji.

    The problem may be there.

    manfredman

    (@manfredman)

    Ok .. my SQL-Server use latin1 (iso-8859-1)And it works with al other Pages on my HP with UNICODE up to version UNICODE-13
    Look Adress on my Footer:
    https://claudia-braeuer.de/
    And it wil be like it is.

    Plugin Author Stefano Lissa

    (@satollo)

    That is because WP stores with a special encoding all things. Did you check the newsletter status page? what is reported about the database charset?

    Are you really using SQL server (Microsoft)?

    manfredman

    (@manfredman)

    Status from Mailserver:
    Database Charset OK Charset: utf8mb4
    Blog Charset OK Charset: UTF-8

    eturn path OK Some providers require the return path domain claudia-braeuer.de to be identical to the sender domain claudia-braeuer.de. See the main settings.
    Blog Charset OK Charset: UTF-8
    PHP version OK Your PHP version is 7.3.11-nmm1
    Curl version OK Version: 7.58.0
    SSL Version: OpenSSL/1.1.1
    Addons update OK Newsletter Addons can be updated
    PHP execution time limit OK Your PHP execution time limit is 600 seconds and can be eventually changed by Newsletter
    Home URL OK Value: https://claudia-braeuer.de/
    WP_CONTENT_URL OK Value: https://claudia-braeuer.de/wp-content
    Database Charset OK Charset: utf8mb4
    If you experience newsletter saving database error
    Database wait timeout OK Your database wait timeout is 120 seconds
    Database table creation OK
    Database table change OK
    WordPress transients OK
    Newsletter schedule timing OK Next execution is planned in 16 seconds (negative values are ok).

    Server Linus (Al Inclusive)

    • This reply was modified 6 months ago by manfredman.
    Plugin Author Stefano Lissa

    (@satollo)

    You should see the button “Try tables upgrade”, try that procedure.

    manfredman

    (@manfredman)

    An i have use it..
    But it will show again.

    Plugin Author Stefano Lissa

    (@satollo)

    The button does not disappear. It’s ok.
    Can you create a standard newsletter, not using the composer, and using the “blank” theme and copy and past there some emoji?

    When saved, are they kept?

    Stefano.

    manfredman

    (@manfredman)

    I only have problems with the list creator and the Welkome Mail.
    If there is an option to use external text, that’s fine.
    I also can’t use shortcodes to import text.
    Shortcodes also do not work in this greeting editor

    • This reply was modified 6 months ago by manfredman.
    • This reply was modified 6 months ago by manfredman.
    • This reply was modified 6 months ago by manfredman.
    Plugin Author Stefano Lissa

    (@satollo)

    Hi the welcome email is saved using the wordpress options so it should not be affected by those problems… but if your options table is not utf8mb4 you could face it.

    You can ask a technician to convert the wp_options table to utf8mb4:

    ALTER TABLE
    wp_options
    CONVERT TO CHARACTER SET utf8mb4
    COLLATE utf8mb4_unicode_ci;

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Cant save UNICCODE at List Build Editor’ is closed to new replies.