hmmm... not sure... I would check the collation to make sure its
utf8_unicode_ci and that the tables are InnoDB / utf8_general_ci... at
least that's what I've used and its worked.
my 2 cents.
j
On 24-Aug-08, at 11:48 AM, Maxime P wrote:
Thank you Jonathan and no problem for your french.
You can answer me in english.
I've already done that but it don't works, i try everything.
I put:
In my bootstrap:
---------
try {
$db = Zend_Db::factory($config->db);
$db->query("SET NAMES 'utf8'");
$db->internalEncoding = 'utf-8';
$db->databaseEncoding = 'utf-8';
Zend_Db_Table::setDefaultAdapter($db);
}
...
$view = new Zend_View(array('encoding'=>'UTF-8'));
---------
in my layout.phtml
<?php header('Content-type: text/html; charset=UTF-8'); ?>
<head><meta http-equiv="Content-Type" content="text/html;
charset=utf-8"
/></head>
Only the data from the database appear with errors '?'. I don't
understand
why? because the charset of the database is utf-8.
I think $db->query("SET NAMES 'utf8'"); don't work for all request.
Can you help me? Thks!
Jonathan Lebensold wrote:
salut Maxime,
je m'excuse pour mon français briser...
il faut que tu ajustes le configuration de caractères avant que tu
faits des transaction avec ton base de données.
Avec Zend_Db et MySQL, dans ton bootstrap.php ou n'importe quelle
fichier qui comprend ton configuration de Zend_Db, il faut metre "SET
NAMES 'utf8'" comme ça:
$db = Zend_Db::factory($config->db->adapter, $config_values);
// for Unicode support
$db->query("SET NAMES 'utf8'");
Zend_Db_Table::setDefaultAdapter($db);
bonne chance,
j
On 24-Aug-08, at 9:03 AM, Maxime P wrote:
Bonjour,
Mon problème se situe au niveau des données qui sont issues de la
base de
données et donc les caractères spéciaux s'affichent mal. Peux-tu me
dire
comment tu as procédé?
Merci d'avance!
Cordialement,
quazardous wrote:
hi,
I m french and I want to use character encoding with zf...
So my question is : what's the good stategy between db/input/output
components ...
=> fot database it seams easy :
define an internal_encoding and a database_encoding ans subclass
Zend_Db_Adapter_Pdo_Mysql (ie for Mysql Pdo) :
----------
class Encoding_Db_Adapter_Pdo_Mysql extends
Zend_Db_Adapter_Pdo_Mysql
{
protected $_internalEncoding;
protected $_databaseEncoding;
....
}
---------
overwrite query and fetch functions with mbstring stuff...
=> for inputs ust subclass zend_filter in the same way.j
=> but for outputs it's not so simple :
using mbstring.encoding_translation On is not very clean :
- side border effect on zf implementation (Zend_Cache uses
ob_start)
- too much server side
...
I m thinking about using a Encoding_Dummy_Cache_Frontend_Page
class...
This class will just use ob_start with a mb_string callback
function...
And subclassing Zend_Cache_Frontend_Page in
Encoding_Cache_Frontend_Page
to overwrite the function _flush() with some mbstring stuff....
your advise ?
--
View this message in context:
http://www.nabble.com/Charset-encoding-integration-stategy-in-ZF-%3A-how---tp13611650p19130455.html
Sent from the Zend Framework mailing list archive at Nabble.com.
--
View this message in context:
http://www.nabble.com/Charset-encoding-integration-stategy-in-ZF-%3A-how---tp13611650p19131634.html
Sent from the Zend Framework mailing list archive at Nabble.com.
