News Feed
Sections




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

Vinu Thomas' Blog:
Modifying your MySQL databases to be UTF-8 compliant
December 28, 2006 @ 07:47:00

There's a quick tip from Vinu Thomas on his blog for anyone having issues with UTF-8 data in a MySQL database (as accessed by PHP).

Most of us have had problems with UTF-8 problems in PHP and MySQL. Here's how to modify your database and table to be UTF-8 compliant. Most of the time we do set the character set to utf8 but forget to set the collation set to utf8.

He includes both SQL statements you'll need to make the transition - two ALTER statements that update the properties of a database and change the encoding on a specific table to UTF-8 compatibility.

0 comments voice your opinion now!
mysql database modify utf8 compliant alter sql statement mysql database modify utf8 compliant alter sql statement


blog comments powered by Disqus

Similar Posts

Felix Geisendorfer's Blog: Migrating from WordPress to CakePHP

DevShed: Working with MySQL Result Sets and the Decorator Pattern in PHP

Job Posting: Codilink S.L. Seeks Symbian/PHP/MySQL Developers (Barcelona, Spain)

Volker Dusch's Blog: References suck! - Let's fix MySqli prepared statements!

DevShed: Paginating Result Sets for a Search Engine Built with MySQL and PHP 5


Community Events





Don't see your event here?
Let us know!


developer threedevsandamaybe framework podcast series configure refactor install language unittest introduction community wordpress list interview code opinion testing release laravel

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework