[#24697] - [4.0] Unable to save Article with Emoji in it
- Closed
- 23 Apr 2019
- Medium
- Build: staging
- # 24697
Steps to reproduce the issue
Create an article, add Emoji from Toolbar, try to save it.
Expected result
Should save the emoji and display on frontend.
Actual result
Save failed with the following error: Incorrect string value: '\xF0\x9F\x94\xA2
System information (as much as possible)
Joomla 4.0 Alpha 8.
PHP 7.2.15
MySQLi 5.5.5-10.1.38-MariaDB
Additional comments
I made sure the #__conent table and columns are utf8mb4 collate (which I think is default in J4).
joomla-cms-bot
- | Labels |
Added:
?
|
||
| Labels |
Added:
J4 Issue
|
||
| Status | New | ⇒ | Information Required |
| Status | Information Required | ⇒ | Discussion |
It works in Joomla 3 :(
No its nothing to do with anything there. Inserting an emoji in the article title works perfectly when done directly in the database. It is an issue somewhere with the joomla validation code
I repeat - it is nothing to do with the mysql field type as you can successfully insert the multibyte character directly in the database AND it worked in joomla 3 with the same mysql settings
@brianteeman Just to understand: When you say "directly in the database" you use the CLI or a PHP based tool like phpMyAdmin? The latter would be closer to what Joomla does (using PHP).
It may be that both of you are right, after all
I mean directly in the database not via php with heidisql or sequel pro
Please let me know if any of you would like any additional information or would like me to test anything?
I also went ahead and changed the driver from Mysqli to Mysql (PDO) and now the system info reads the following info as well.
| Database Collation | Database Connection Collation |
|---|---|
| utf8mb4_unicode_ci | utf8_general_ci |
| Title |
|
||||||
Closed as having Pull Request.
| Status | Discussion | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2019-04-23 14:19:53 |
| Closed_By | ⇒ | franz-wohlkoenig |
didn't work for me either.
@chetanmadaan can you please comment on #24704
@chetanmadaan can you please comment on #24704
Just did.
related #7803?