August 13

Joomla 1 and Joomla 1.5 Cyrillic issue fix:

In the file /libraries/joomla/database/database.php
Need to find the string $this->_table_prefix = $table_prefix; and put the following code after it:

@mysql_query("SET NAMES 'cp1251'", $this->_resource);
@mysql_query( "set session character_set_server=cp1251", $this->_resource );
@mysql_query( "set session character_set_database=cp1251", $this->_resource );
@mysql_query( "set session character_set_connection=cp1251", $this->_resource );
@mysql_query( "set session character_set_results=cp1251", $this->_resource );
@mysql_query( "set session character_set_client=cp1251", $this->_resource );

or, in the case with UTF-8:

@mysql_query("SET NAMES 'utf8'", $this->_resource);
@mysql_query( "set session character_set_server=utf8", $this->_resource );
@mysql_query( "set session character_set_database=utf8", $this->_resource );
@mysql_query( "set session character_set_connection=utf8", $this->_resource );
@mysql_query( "set session character_set_results=utf8", $this->_resource );
@mysql_query( "set session character_set_client=utf8", $this->_resource );


Copyright 2021. All rights reserved.

Posted 13 August 2019 by admin in category "simple memo

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.