UTF8 on display, wrong in database because twice converted (solved)

babynus wrote: It has nothing to do with browser cache as it is pure PHP concern.

babynus wrote: Are you sure you are using ../files/config/parameters.php ?

babynus wrote: You can check in /tool/parametersLocation.php the location of your parameters file.

babynus wrote: It must work as it will do exactely the same than commenting condition as you first did.

Jean-Luc wrote: Added in /files/config/parameters.php :

…
$logFile='../files/logs/projeqtor_${date}.log';
$logLevel='2';
$enforceUTF8=true;
//======= END

but don’t work, even with browser cache void.
Condition re-commented.

Jean-Luc wrote: After migration to v4.4, flag 'enforceUTF8' is not set because existing, but need because UTF8 already enforced.
So I have commented the condition “if (isset($enforceUTF8) and $enforceUTF8)”.
But the proper method is to set the flag. Where to define it ?

self::$connexion->query("SET NAMES utf8");

babynus wrote: the parameter "$enforceUTF8" is used to force the "self::$connexion->query("SET NAMES utf8");"
This will ensure that data is stored in UTF-8, even if your server is not fully configured in UTF-8.

But it is dedicated to new installs only.
If you have existing data, they will not be conveted automatically, because your MySql server in not completely configured in UTF8.
In your case, what you should do is :
- export your data
- convert exported file to UTF-8
- adapt my.ini to be full UTF-8 compliant

[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

- reload your data

All should be clean then.