Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Felix Geisendorfer's Blog:
Enforce utf8 for multiple db connections
Nov 12, 2007 @ 12:55:00

Felix Geisendorfer has another quick CakePHP tip - an update from a previous tip for forcing utf8 connections on multiple databases:

This is just a quick update for Dessert #6 - MySql & UTF-8. I've been using the approach outlined in that old post pretty much until today, when I realized that it has two major flaws: It does not work when using multiple db connections (i.e. using load balancing or connecting to a 3rd party db), and it might interfere with other databases that don't need this utf8 thing to be set.

He includes some code (a quick 13 liner) to take care of this small issue. Check out the comments on the post for an even easier way too.

tagged: caekphp framework multiple database connection utf8 encoding caekphp framework multiple database connection utf8 encoding

Link: