Being more on-topic now, there are a few places where character encoding and in particular UTF-8 can go wrong. The database, the database connection, the code (eg. bad encode/decode), and the output.

You didn’t say what kind of output you get instead of “Séan”. I think we’ll need that information to debug this.