| 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?
|
|
|
|
|
|
|
|
| Re: multibyte error [message #7103 is a reply to message #7102] |
Mon, 11 December 2017 09:07  |
barnabooth
Messages: 12
Registered: February 2011
|
Junior Member |
|
|
Yes, I can (and did) create a new entry
Эверетт, Хью
which (for instance) does not function on my localhost installation.
Do I understand it correctly that there is no need for any manual utf-8 additions in the framework whatsoever (in .htaccess .user.ini or config-files in the include directory)?
If so, then there is probably something with fpm/fast cgi that I don't get, as the problem appeared after the shift from apache2.
Anyway, thank you for your quick response!
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
