Upgrade database to utf8mb4 #103

New Issue

2026-01-06T08:38:14Z

ken_fallon commented

2026-01-06 08:38:14 +00:00

Extended characters like 😁 are causing a problem in comments but also in show notes.

[06-Jan-2026 08:31:40 UTC] PHP Fatal error: Uncaught mysqli_sql_exception: Incorrect string value: '\xF0\x9F\x98\x81\x0D\x0A' for column hpr_hpr.comments.comment_text at row 1 in /home/hpr/public_html/cms/comment_process.php:126

Extended characters like 😁 are causing a problem in comments but also in show notes. [06-Jan-2026 08:31:40 UTC] PHP Fatal error: Uncaught mysqli_sql_exception: Incorrect string value: '\xF0\x9F\x98\x81\x0D\x0A' for column `hpr_hpr`.`comments`.`comment_text` at row 1 in /home/hpr/public_html/cms/comment_process.php:126 - https://stackoverflow.com/questions/1168036/how-to-fix-incorrect-string-value-errors - https://www.w3tutorials.net/blog/incorrect-string-value-when-trying-to-insert-utf-8-into-mysql-via-jdbc/

ken_fallon self-assigned this 2026-01-06 08:38:22 +00:00

ken_fallon commented

2026-08-05 12:24:14 +00:00

database now supports utf8mb4_unicode_ci

ALTER TABLE   eps
  CONVERT TO CHARACTER SET utf8mb4  
  COLLATE utf8mb4_unicode_ci;

and

ALTER TABLE assets ENGINE=InnoDB;

for every table

database now supports utf8mb4_unicode_ci ``` ALTER TABLE eps CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ``` and ``` ALTER TABLE assets ENGINE=InnoDB; ``` for every table

ken_fallon closed this issue

2026-08-05 12:24:14 +00:00

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: HPR/hpr_hub#103