Problem with greek characters (unicode) after server change

General questions relating to Joomla! 1.5 There are other boards for more specific help on Joomla! features and extensions.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Locked
CDrosos
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Sun Nov 25, 2012 7:48 pm

Problem with greek characters (unicode) after server change

Post by CDrosos » Tue Mar 31, 2015 2:06 pm

Hello guys, im a web designer mostly wordpress and today i have move a joomla site from one server to another, ( the site is mfnano.com )
I have just download all the files, export the databases and then move the files and import the database with some minor changes on the configuration.php
But now the greek characters appear as ???, do you know why?

Im using Joomla 1.5.x
In the previous server php version was 5.3.3 with run php as apache module
now in the new server is 5.5 with fast cgi

What i have to do? thanks

User avatar
brian
Joomla! Master
Joomla! Master
Posts: 12781
Joined: Fri Aug 12, 2005 7:19 am
Location: Leeds, UK
Contact:

Re: Problem with greek characters (unicode) after server cha

Post by brian » Tue Mar 31, 2015 2:10 pm

Check the database collation
"Exploited yesterday... Hacked tomorrow"
Blog http://brian.teeman.net/
Joomla Hidden Secrets http://hiddenjoomlasecrets.com/

CDrosos
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Sun Nov 25, 2012 7:48 pm

Re: Problem with greek characters (unicode) after server cha

Post by CDrosos » Tue Mar 31, 2015 5:55 pm

its utf8_general_ci
it should be utf8_unicode_ci?

i would like to try this code before i get everything from the database, as i see this fix similar problems

$mysqli->set_charset('utf8')

but i dont know where i have to put this code

User avatar
brian
Joomla! Master
Joomla! Master
Posts: 12781
Joined: Fri Aug 12, 2005 7:19 am
Location: Leeds, UK
Contact:

Re: Problem with greek characters (unicode) after server cha

Post by brian » Tue Mar 31, 2015 6:01 pm

Its pretty simple
What was it before? Thats what it should be now
"Exploited yesterday... Hacked tomorrow"
Blog http://brian.teeman.net/
Joomla Hidden Secrets http://hiddenjoomlasecrets.com/

CDrosos
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Sun Nov 25, 2012 7:48 pm

Re: Problem with greek characters (unicode) after server cha

Post by CDrosos » Tue Mar 31, 2015 6:16 pm

if this was the case then i would not have any problems, i didnt first change the collation then restore the site and then wonder what is going wrong... i have just copy all the files and export / import the databases,
nothing changed
utf8_general_ci is on the old server too, i have just check
where i can put the 'set names utf8' code? this might help


Locked

Return to “General Questions/New to Joomla! 1.5”