Problem with Collation | Joomla Support | Forum Archive

Many thanks for your reply Ovidiu. The collation for the orginal datebase is "utf8_general_ci".  I use the default setting when I reinsall the website on the other server. After that I change the collation back to "utf8_general_ci" again using (Phoca Changing Collation) utility.  

I checked every single in the database to make sure that it all contain the same collation, I correct just few instances but the pproblem still the same?!!

Many thanks for your reply. I already did that today earlier and it sorted and the website worked. But sorry I couldn't write to the fourm because I was busy.

However I still thinking why collation couldn't sorted using Xcloner!

Here is a copy of the file

<?php

class JConfig {

var $offline = '0';

var $editor = 'jce';

var $list_limit = '20';

var $helpurl = 'http://help.joomla.o.....&#039;;

var $debug = '0';

var $debug_lang = '0';

var $sef = '0';

var $sef_rewrite = '0';

var $sef_suffix = '0';

var $feed_limit = '10';

var $feed_email = 'author';

var $secret = 'HjMuZMB2OfyH';

var $gzip = '0';

var $error_reporting = '-1';

var $xmlrpc_server = '0';

var $log_path = '/.../logs';

var $tmp_path = '/.../alsi.net/tmp';

var $live_site ='http://www.alsiyasia.....&#039;;# '';

var $force_ssl = '0';

var $offset = '0';

var $caching = '0';

var $cachetime = '15';

var $cache_handler = 'file';

var $memcache_settings = array();

var $ftp_enable ='0';# '0';

var $ftp_host = '127.0.0.1';

var $ftp_port = '21';

var $ftp_user = '';

var $ftp_pass = '';

var $ftp_root = '';

var $dbtype = 'mysql';

var $host ='localhost';# 'localhost';

var $user ='xxxxxxx';# 'xxxxxxx';

var $db ='xxxxxx';# 'xxxxxx';

var $dbprefix = 'jos_';

var $mailer = 'mail';

var $mailfrom = 'xxxxxxx';

var $fromname = 'xxxxxxxx';

var $sendmail = '/usr/sbin/sendmail';

var $smtpauth = '0';

var $smtpsecure = 'none';

var $smtpport = '25';

var $smtpuser = '';

var $smtppass = '';

var $smtphost = 'localhost';

var $MetaAuthor = '1';

var $MetaTitle = '1';

var $lifetime = '15';

var $session_handler = 'database';

var $password ='xxxxxx';# 'Pr97X38iQ';

var $sitename = 'alsiyasia.net';

var $MetaDesc = 'Joomla! - the dynamic portal engine and content management system';

var $MetaKeys = 'joomla, Joomla';

var $offline_message = 'This site is down for maintenance. Please check back again soon.';

}

?>