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.

Database migration ...
 
Notifications
Clear all

Database migration and utf8 char conversion

5 Posts
2 Users
0 Reactions
2,275 Views
VINCENT Philippe
(@phvincent)
Posts: 11
Active Member
Topic starter
 
[#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


 
Posted : 08 Dec 2018 14H44
(@babynus)
Posts: 14952
Member Admin
 

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


 
Posted : 08 Dec 2018 15H58
VINCENT Philippe
(@phvincent)
Posts: 11
Active Member
Topic starter
 

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


 
Posted : 08 Dec 2018 17H00
(@babynus)
Posts: 14952
Member Admin
 

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


 
Posted : 11 Dec 2018 11H17
VINCENT Philippe
(@phvincent)
Posts: 11
Active Member
Topic starter
 

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


 
Posted : 11 Dec 2018 11H57
Share:

Scroll to Top