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.
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 years, 5 months ago by
manfredman.
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.
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.
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)?
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 years, 5 months ago by
manfredman.
You should see the button “Try tables upgrade”, try that procedure.
An i have use it..
But it will show again.
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.
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;