[#24704] - [4.0] Enable utf8mb4 in database connections
- Fixed in Code Base
- 23 Apr 2019
- Medium
- Build: 4.0-dev
- # 24704
- Diff
- joomla:utf8mb4-4.0
- Pending continuous-integration/travis-ci/push The Travis CI build is in progress Details
- Pending continuous-integration/drone/push this build is pending Details
- Pending continuous-integration/appveyor/branch Waiting for AppVeyor build to complete Details
- Pending Hound Hound is busy sniffing around... Details
User tests: Successful: Unsuccessful:
Pull Request for Issue #24697
Enables UTF8MB4 support in the database drivers when available
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | Libraries |
| Title |
|
||||||
:) same error for me after applying the patch and trying to create an article with an emoji as the title
Save failed with the following error: Incorrect string value: '\xF0\x9F\x8E\x81\xE2\x9C...' for column 'title' at row 1
correction:
I still cannot insert an emoji in the title of a new article
But I can now insert an emoji in the title of an existing article
The difference between the two cases is either due to the INSERT vs UPDATE in the sql
OR it is failing at the create alias stage
OK So at minimum I'd hope that the Database Connection Collation screenshot in the original PR is switched to be utf8mb4. Can you guys confirm?
| Labels |
Added:
?
|
||
Ugh I made a really stupid bug in the code. Can you try again please
Checking now...
Awesome.
System config now reads collect collation for both DB Drivers and I am able to save Emoji's as well.
Database Connection Collation |
-- | --
utf8mb4_general_ci
This passed on drone but it hasn't apparently sent the response back to github http://ci.joomla.org/joomla/joomla-cms/17341 :(
| Status | Pending | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2019-04-23 16:02:24 |
| Closed_By | ⇒ | wilsonge |
Just confirming it worked for me too
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24704.
Just confirming it worked for me too
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24704.
No worries. Thanks for reporting it!
Does not solve the issue here.