utf 8

This article is part of a series of articles that explains how to create a framework with the Symfony2 Components: 1, 2, 3,

We're all being drilled over and over again to always use mysqli::escape_string, PDO::quote, or preferably prepared statements when escaping user-supplied strings for use in MySQL queries.

Dealing with character sets and encodings is tough. As long as you're dealing only with English texts you in a luxury situation and can mix utf-8 and iso-8859-1 encoded texts and most (all?) of your tests will work.

Some of your users, like me, with strange names ("Schlüter") will be annoyed as your application breaks them ("Schlüter"), but these will be edge cases.

There are bigger issues with mixing encodings but that's not what I wanted to tell now.

Phil Sturgeon has posted a quick guide on working with UTF-8 support in the CodeIgniter framework.

After spotting some null values in a few of his form fields following an Ajax request, Pablo Viquez decided to track down his issue: