Character encodings and databases

[Mark Fowler]

On Thu, Jun 19, 2014 at 3:23 PM, Mark Fowler <mark at twoshortplanks.com> 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.

Mark.