Forum

Database migration ...
 
Notifications
Retirer tout

Database migration and utf8 char conversion

5 Posts
2 Utilisateurs
0 Reactions
2,274 Vu
VINCENT Philippe
(@phvincent)
Posts: 11
Active Member
Début du sujet
 
[#5612]

Hello All

I've successfully migrated my projeqtor DEV environment from 6.2.4 to 7.2.7 (I was doubtful but finally it's a great job from you to maintain migration pathes 🙂 ).

Database is fine except that existing non-ascii chars are not well displayed.
Initial v6 DB had UTF8 charset and utf8_general_ci collation; same for new v7 database.
Did I miss something in the migration setup?

I'd like to solve this issue before migrating my PROD environment for 2 main reasons:
1) providing a correct data display to my users (obvious)
2) more important: make the projeqtor API return well-encoded chars! This is because I developed php scripts using API and json_decode()... which fails when API return json objects with incorrect chars

Thanks for your advices


 
Posté : 8 Déc PM 14:1212
(@babynus)
Posts: 14952
Membre Admin
 

Please explain :
How you installed Dev env ( I guess charset issue appears here before migration )
Hiw you migrated


 
Posté : 8 Déc PM 15:1212
VINCENT Philippe
(@phvincent)
Posts: 11
Active Member
Début du sujet
 

DEV was installed with standard method : unzipping v7 package in a new htdocs folder (xampp), leaving the v6 database online to start migration process at first admin login.
I've checked my database is correctly setup and populated after migration.

Continuing investigation I found a workaround: adding "$enforceUTF8='1';" in my parameters.php file (it was present in v6 but disappeared in v7).
Issue seems to be solved.
If you think there's a better way, please let me know.

Cheers


 
Posté : 8 Déc PM 17:1212
(@babynus)
Posts: 14952
Membre Admin
 

Issue was to unzip in new folder : you should overwrite existing code with new one.


 
Posté : 11 Déc AM 11:1212
VINCENT Philippe
(@phvincent)
Posts: 11
Active Member
Début du sujet
 

Hello Dear Babynus

Ok... I didn't pay attention to the fact that new release has no "default" parameters.php file, so I guess my old parameters would have been preserved.
Thanks for your support and have a nice day


 
Posté : 11 Déc AM 11:1212
Share:
Retour en haut