The first type:
$conn [' host '] = ' 127.0.0.1 ';
$conn [' username '] = ' 56_ '. $tenant [' tenant '];
$conn [' password '] = $tenant [' Password '];
$conn [' dbname '] = ' 56_ '. $tenant [' tenant '];
$conn [' charset '] = ' UTF8 ';
$this->_db = zend_db::factory (' Pdo_mysql ', $conn);
Zend_db_table::setdefaultadapter ($this->_db);
Sets the default adapter for abstract class Zend_db_table objects
Zend_registry::set (' db ', $this->_db);
The second type:
<?php $dbAdapter =zend_db::factory ($config->general->db->adapter,
$config->general->db->toarray ());
$dbAdapter->query ("SET NAMES UTF8");?>
The third type: normal PHP page connection is set to UFT8 encoding
<?php
Database connection
$conn = @mysql_connect ("localhost", "root", "");
if (! $conn) {
Die ("Connection Database failed:". Mysql_error ());
}
mysql_select_db ("TestDB", $conn);
Character encoding Conversion _ Read database
mysql_query ("Set character set ' UTF8 '");
Character encoding Conversion _ Write database
mysql_query ("Set names ' UTF8 '");
?>
Zend Framework Settings database connection encoded as UTF8 three ways