Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Caracter non UTF8 w...
 
Notifications
Clear all

Caracter non UTF8 with v7.2.1

6 Posts
2 Users
0 Reactions
2,388 Views
(@maxdevis)
Posts: 3
Active Member
Topic starter
 
[#5400]

Hi Team

Since apply version v7.2.1 all task and info inside task are not correctly encoding as you can see on this screeshoot

i have follow indication fromthis post https://www.projeqtor.org/fr/kunena/2-submit-issues/5799-utf8-on-display,-wrong-in-database-because-twice-converted-solved?start=18

But no way...

My Database is enconding in utf8_general_ci

Someone have the same issue ? And get solution ?
Thanks a lot


 
Posted : 04 Sep 2018 23H42
babynus
(@babynus)
Posts: 14952
Member Admin
 

How did you migrate ?
Did you backup / copy database ?
Did you install new code or overwrite existing ?


 
Posted : 05 Sep 2018 0H55
(@maxdevis)
Posts: 3
Active Member
Topic starter
 

Hi Thanks for answer

Yes replace code like all the time
I did copy but restauration is ok to other instance database..

Thanks 🙂


 
Posted : 05 Sep 2018 1H00
babynus
(@babynus)
Posts: 14952
Member Admin
 

I did copy but restauration is ok to other instance database..

It may be source of issue.
If your server is not fully configured in UTF-8 (even if collation is utf8_general_ci) export / import may lead to incorrect charset.

Check directly in DB if characters are stored the same way as origin.
Attention, sometimes, your source is not correctly stored in UTF-8 (you'll see accentuated charactes like Ã.. with phphMyAdmin) and export / import set it the good way.
If it is the case add (or change) value for parameter enforceUTF8 in parameters.php.
If your DB is correctly stored in UTF-8,
$enforceUTF8 = '1';
in parameters.php should display correctly accentuated characters.
Otherwise, set
$enforceUTF8 = '0'; // Or remove the line
If accentuated characters are correctly displayed, it means your DB is not correctly configured.


 
Posted : 05 Sep 2018 1H15
(@maxdevis)
Posts: 3
Active Member
Topic starter
 

Hi

So... its very bad jajaj
You right all database now is not correctly encoding, and before updating yes... So if i force inside parameter dont change anything... I must change all manually i guest...

Do you have SQL syntax for automatic update all é as é ?

Thanks a lot


 
Posted : 05 Sep 2018 1H55
babynus
(@babynus)
Posts: 14952
Member Admin
 

Do you have SQL syntax for automatic update all é as é ?

There is no.

You must export DB.
Convert dump file.
Reimport.


 
Posted : 05 Sep 2018 10H59
Share:

Scroll to Top