News Feed
Jobs Feed
Sections




Recent Jobs

News Archive
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



Similar Posts

Unravel the Music Blog: Partial-page caching with Memcached and PHP in 3 easy steps

Guilherme Blanco's Blog: register_superglobal("¯name"¯);

DevArticles: Building an AJAX-Based Chat - Interacting With a Database

Royal Pingdom: What the Web's most popular sites are running on

Ryan Malesevich's Blog: iTunes Stats for Macintosh with PHP & MySQL Part 2


Community Events









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


symfony security microsoft developer sqlserver release feature wordpress framework drupal job podcast opinion zendframework windows facebook extension codeigniter conference doctrine

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