Doctrine2 and UTF-8

Question

Hey everybod out there :) I'm using CodeIgniter and Doctrine2 as my ORM. I'm having problem with storing and retrieving UTF-8 texts from my database.

I've red something about PostConnection Events but im not really sure where to add this stuff :/

My Database and the tables have UTF-8 Encoding.

Can some tell me how i can fix this? :)

greetings

Have a look at: http://stackoverflow.com/questions/5078786/showing-instead-of/5078800#5078800 — Michiel Pater, Mar 23 '11 at 15:05

score 5 · Accepted Answer · answered Aug 24 '11 at 12:13

5

You have to tell your entityManager explicitly you want to use UTF-8. You don't show any code, so I just give you my snippet:

// $entityManager is an instance of EntityManager
// Add UTF8 handler to EntityManager
$entityManager->getEventManager()->addEventSubscriber(
                new \Doctrine\DBAL\Event\Listeners\MysqlSessionInit('utf8', 'utf8_unicode_ci')
);

This worked for me. Also, make sure you only use multibyte functions of PHP (http://php.net/manual/en/book.mbstring.php).

answered Aug 24 '11 at 12:13

Rene Terstegen

7,911
18
52
74

As the MysqlSessionInit is used I supose the solution works just for MySQL database, doesn't it? – Petr Peller Dec 21 '11 at 21:50
@PetrPeller, yeah, this is strictly MySQL related. – Ocramius Jan 31 '12 at 08:19

Doctrine2 and UTF-8

1 Answers1