Hi list,
I have a funny problem with Peer Objects and UTF-8 encoded databases.
Here is a sample of my database :
CREATE DATABASE `poptract` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `poptract`;
CREATE TABLE `projets` (
`idProjet` bigint(20) NOT NULL AUTO_INCREMENT,
`libelle` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`dateDebut` date DEFAULT NULL,
`statut` smallint(6) DEFAULT NULL,
`dateFin` date DEFAULT NULL,
`idClient` bigint(20) DEFAULT NULL,
`baseNom` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`dateCreation` date DEFAULT NULL,
PRIMARY KEY (`idProjet`),
KEY `WDIDX11986616292` (`libelle`),
KEY `WDIDX11986616293` (`idClient`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
All my files are UTF-8 encoded, I have added
charset: utf-8
in my settings.yml,
charset: UTF-8
in view.yml's metas section,
param:
encoding: utf8
in databases.yml.
And now the funny part :
In my action :
$this->projets = ProjetsPeer::retrieveByPK(11);
In my view :
var_dump($projets)
returns me :
object(Projets)#97 (14) {
["idprojet:protected"]=>
string(2) "11"
["libelle:protected"]=>
string(16) "é a a a test è"
["datecreation:protected"]=>
NULL
["datedebut:protected"]=>
NULL
["statut:protected"]=>
NULL
["datefin:protected"]=>
NULL
["idclient:protected"]=>
string(1) "1"
["basenom:protected"]=>
string(6) "blabla"
["alreadyInSave:protected"]=>
bool(false)
["alreadyInValidation:protected"]=>
bool(false)
["validationFailures:protected"]=>
array(0) {
}
["_new:private"]=>
bool(false)
["_deleted:private"]=>
bool(false)
["modifiedColumns:protected"]=>
array(0) {
}
}
when
echo $projet->getLibelle()
gives me
é a a a test è <== see these characters ?
Any Ideas ?
Peter
P.S. : I have the same result with PHP 5.1.2 / Apache 2.2.0 / MySQL
5.0.20 / Symfony 1.0.10 / Win XP Pro SP2 and with gentoo 2.6.19 / PHP
5.2.2-pl1-gentoo / Mysql 5.0.26 / Symfony 1.0.6 / Apache 2.0.58
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
