multibyte error [message #7100] |
Mon, 11 December 2017 06:54 |
barnabooth
Messages: 12 Registered: February 2011
|
Junior Member |
|
|
I have been trying to figure out the following problem for several days now, but I am afraid I can't come any further than this. The problem is:
When I try to insert non-latin characters I get the following error message:
Fatal Error: MySQL: Incorrect string value: '\xD0\xAD\xD0\xB2\xD0\xB5...' for column 'new_value' at row 1 (# 256)
Error in line 1192 of file '/var/www/html/radicore/includes/dml.mysqli.class.inc' ...
As far as I understand this is a multibyte-error.
My database (mariaDB) is entirely set in utf8mb4_unicode_ci and when I access my db from phpMyAdmin for instance, I have no problem inserting non-latin characters. This -- I think -- excludes any issues with server or php.ini settings, and instead points to my radicore-setup. (And when they are inserted through phpMyAdmin they also shows up correctly in radicore).
The problem appeared after a reinstallation when I shifted from apache2 to FPM/FastCGI
Before I had php_value settings for utf8 in the .htaccess file, which is not possible with FPM. Instead I have tried to include
default_charset = "UTF-8"
mbstring.internal_encoding "UTF-8"
in a .user.ini file at radicore-root and my application root (also tried with "utf8mb4" without any success).
Is it possible that you (or someone else) could point me at the right direction where to look for a solution of this problem?
|
|
|