RSS
News
This archive is experimenting with various Unicode versions in some places! - Back to Unicode 14.0

Primarily for sorting and counting purposes (some story entries use it as well), but everything else uses the binary form of UTF-8.

Never tested emoji yet, but they should work...

Doesn't work, even directly through the database. Someday, I will figure out why.

Update 2026/09/18: EMOJIS NOW WORK! It was database setting related. 😁👍

MariaDB: 10.6 to 11.4: old-mode explicitly needs to be empty due to old-mode mapped to utf8_is_utf8mb3 by default, so: 'old-mode = '
MariaDB: 11.8 and newer: Nothing to do; character_set_system will be mapped to utf8mb4, overriding old-mode.

Reference: https://stackoverflow.com/questions/67696563/setting-utf-8-in-mariadb-server-ignores-character-set-system

Update 2026/09/19: There's actually a one-line change you can make in includes/mysqli_functions.php. I added it to the file so you can comment and uncomment which one you want.

Original line:
mysqli_query($mysqli_access, "SET NAMES UTF8;");

Added line (commented out by default):
mysqli_query($mysqli_access, "SET NAMES UTF8MB4;");

UTF8MB4 supports emojis and other multibyte characters that UTF8 (mb3) cannot.

Another line (should be uncommented if UTF8MB4 is also used):
mysqli_query($mysqli_access, "SET collation_connection = utf8mb4_bin;");



Ami Sapphire on 2026/09/17 • 16:25
[ 3 Comments ]
Comments

<

>

&

'

"

マリウス

マ リ ウ ス

防

- Ami Sapphire on 2026/09/18 • 08:17

😁👍

- Ami Sapphire on 2026/09/18 • 13:38

🤦‍♀️

- Ami Sapphire on 2026/09/19 • 15:19