Charset And Collation
David
Why are SP Page Builder tables created with "utf8" character set instead of "utf8mb4" like the rest of Joomla tables?
For example:
This causes the system to use the "utf8_general_ci" collation for text fields in those tables, instead of the "utf8mb4_unicode_ci" collation used in Joomla, which may be a problem on multi-language sites with special characters.
Toufiq
Accepted AnswerHi there,
I appreciate you reaching out. I sincerely apologize for this oversight. We set it for global. But, If you need utf8mb4_unicode_ci then you can create a database before install Joomla.
-Thanks
David
Accepted AnswerHi Toufiq,
Thank you for your reply.
Creating a database before installing Joomla is not enough, because in the SQL scripts to create the SP Page Builder tables, the charset "utf8" is specified and therefore, although the database is "utf8mb4", the tables end up being created with what has been forced in the script.
I already know how to fix this situation by modifying the scripts before installing, but I would like to know if this issue will be fixed in the next version.
Thanks.