Joomla! Forum - community, help and support

Code: Select all

}

Code: Select all

?>

Code: Select all

header("Content-Type: text/html; charset=ENCODING");

Code: Select all

header("Content-Type: text/html; charset=windows-1251");

Code: Select all

//        @mysql_query("SET NAMES 'utf8'", $this->_resource);

Code: Select all

        @mysql_query("SET NAMES 'utf8'", $this->_resource);

Code: Select all

}

Code: Select all

?>

Code: Select all

header("Content-Type: text/html; charset=UTF-8");

Code: Select all

DEFINE('_ISO','charset=iso-8859-1');

Code: Select all

DEFINE('_ISO','charset=UTF-8');

Code: Select all

<meta http-equiv="Content-Type" content="text/html;><?php echo _ISO; ?>" />

Code: Select all

<meta http-equiv="Content-Type" content="text/html;<?php echo _ISO; ?>" />

Code: Select all

DROP TABLE IF EXISTS `jos_banner`;
CREATE TABLE `jos_banner` (
  `bid` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `type` varchar(10) collate latin1_general_ci NOT NULL default 'banner',
  `name` varchar(50) collate latin1_general_ci NOT NULL default '',
  `imptotal` int(11) NOT NULL default '0',
  `impmade` int(11) NOT NULL default '0',
  `clicks` int(11) NOT NULL default '0',
  `imageurl` varchar(100) collate latin1_general_ci NOT NULL default '',
  `clickurl` varchar(200) collate latin1_general_ci NOT NULL default '',
  `date` datetime default NULL,
  `showBanner` tinyint(1) NOT NULL default '0',
  `checked_out` tinyint(1) NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `editor` varchar(50) collate latin1_general_ci default NULL,
  `custombannercode` text collate latin1_general_ci,
  PRIMARY KEY  (`bid`),
  KEY `viewbanner` (`showBanner`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;

Code: Select all

<?php
$db = mysqli_connect('localhost','username','password', 'database');
if(mysqli_connect_errno())
{
echo "Cannot connect to the database - incorrect details";
}


$sql = 'SHOW TABLES';
if ( !( $result = $db->query( $sql ) ) ) {
echo '<span style="color: red;">Get SHOW TABLE - SQL Error: <br>' . "</span>n";
}


while ( $tables = $result->fetch_row() ) {
echo $tables[0];
# Loop through all tables in this database
$table = $tables[key($tables)];

if ( !( $result2 = $db->query("ALTER TABLE ".$table." COLLATE utf8_general_ci") ) ) {
echo '<span style="color: red;">UTF SET - SQL Error: <br>' . "</span>n";

break;
}

print "$table changed to UTF-8 successfully.<br>n";

# Now loop through all the fields within this table
if ( !($result2 = $db->query("SHOW COLUMNS FROM ".$table) ) ) {
echo '<span style="color: red;">Get Table Columns Query - SQL Error: <br>' . "</span>n";

break;
}

while ( $column = $result2->fetch_assoc() )
{
$field_name = $column['Field'];
$field_type = $column['Type'];

# Change text based fields
$skipped_field_types = array('char', 'text', 'enum', 'set');

foreach ( $skipped_field_types as $type )
{
if ( strpos($field_type, $type) !== false )
{
$sql4 = "ALTER TABLE $table CHANGE `$field_name` `$field_name` $field_type CHARACTER SET utf8 COLLATE utf8_general_ci";
$result4 = $db->query($sql4);

echo "---- $field_name changed to UTF-8 successfully.<br>n";
}
}
}
echo "<hr>n";
}
$result->free();
$result2->free();
$result4->free();
?> 

Code: Select all

Serious db problem:Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' SQL=SELECT id FROM jos_fb_messages JOIN jos_fb_messages_text ON id=mesid WHERE userid=62 AND name='admin' AND email='[email protected]' AND subject='ışğüçö' AND ip='78.172.162.69' AND message='ış' AND time>='1260090206'