Character encodings and databases

Mark Fowler mark at
Thu Jun 19 20:25:53 BST 2014

On Thu, Jun 19, 2014 at 3:23 PM, Mark Fowler <mark at> wrote:

> There are many ways, but this is my standard simple test: Store
> "\N{SNOWMAN}" in your database.  If the database thinks it's three
> characters long instead of one then the database is storing individual
> bytes that are part of your UTF-8 encoding as characters.

To be explicit, I mean use the SQL LENGTH() function to see how long
the database thinks what it has stored is.


More information about the mailing list