Page 1 of 1

Transfer to new server - French accent problem

Posted: Fri Oct 02, 2015 3:00 pm
by Chacapamac
You can reach the site (temporarly) at —> http://www.pulsionvoyages.grafcomm.ca/index.php

When I transfer that site to this new hosting environment, all the french accent are replaced by �

Their settings (in Joomla administration Systeme infos) are:
- PHP : 5.3.29
- Database Version: 10.0.21-MariaDB
- Database Collation (where I think the problem reside is : N/A (mySQL < 4.1.2)

Their server collation is —> utf8mb4_unicode_ci

The Joomla database collation (I always use) is —> utf8_general_ci

This site work perfectly on the original server and on my Mamp 5.3 local server

When I mount my site (with Akeeba backup) on that new server, I think the accents are obviously not well interpreted by the new environment.

Anybody with more knowledge on that type of situation can help me fix this?

Re: Transfer to new server - French accent problem

Posted: Fri Oct 02, 2015 3:14 pm
by ribo
Try this. Create a new database. Before import db alter this from phpmyadmin

Code: Select all

ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
After restore your back up with akeeba( i use to restore/tranfer with no akeeba but you use akeeba)
Also you can try utf8_general_ci if you want

Re: Transfer to new server - French accent problem

Posted: Sat Oct 03, 2015 1:27 am
by Chacapamac
I want to thank you ribo for your answer. Really appreciated.

I’m not really a pro to work with database

What you want me to do; Tell me if correct

I have the working site on my local mamp without the accent mess.

1— I go to my Mamp PHPMyAdmin on this database

2— I pass that exact query in the input box of SQL query on database ?

Code: Select all

ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
Do I have to change “databasename” by the real full name of the database — e.g. pulsionz_12345
and “tablename” with the actual prefix of the database —e.g. cfgv_

The exact query will be something like

Code: Select all

ALTER DATABASE pulsionz_12345 CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE cfgv_ CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
You also suggest utf8_general_ci - What you think will be better?

Also do I have to adjust my database collation on the import side to match what I choose in the query?

Not Sure????

Re: Transfer to new server - French accent problem

Posted: Sat Oct 03, 2015 2:54 am
by Chacapamac
Thanks Everybody - Find the simple Fix here —> http://forum.joomla.org/viewtopic.php?f ... 0#p3333100

mariadb mysql isn’t compatible with Joomla 1.5 without the fix