search

CONTENIDO / CONTENIDO

CONTENIDO CMS
Other
17 stars 12 forks source link

Smiley breaks Tinymce #380

Closed AndrasDF closed 1 year ago

AndrasDF commented 1 year ago

Entering 😊 in WYSIWYG Editor or 😊 in Source-Editor of the WYSIWYG Editor removes everything after the emoticon and the emoticon itself when saved.

muratpurc commented 1 year ago

The connection to the database is most likely made by using utf8, and you need to change this to utf8mb4 in order to be able to store and retrieve content having unicode, e.g. smileys.

Open your config.php in {installation_path}/data/config/{emvironment}/ and set the database connection setting for 'charset' to 'utf8mb4'. This should solve your issue.

Faar400 commented 1 year ago

When I set up a website in Thai, I also had to convert all table columns with readable characters to UTF8-xxx too, otherwise the Thai characters were saved incorrectly.

muratpurc commented 1 year ago

CONTENIDOs' default charset for database connections is utf8. If you want to use emojis, Asian symbols, mathematical symbols, etc., then you have to change this manually to multi-byte UTF-8 (utf8mb4) after the installation.

We can think about changing the default charset to utf8mb4 and the collation to utf8mb4_unicode_ci in the CONTENIDO setup, so that future installations won't have such issues.

Faar400 commented 1 year ago

Yes, it would be real multilanguage able.

muratpurc commented 1 year ago

The creation of MySQL tables with the charset utf8mb4 on new CONTENIDO installations ist implemented. See pull request #404.