Database CharSet Nightmare

ServiceStack.OrmLite MySql
1

I have a database with table define with different charset. Is there a central method I can hook on to inspect my fields to try to decode the encoding of the character set.

Do we have attribute that can help when we define our data model ?

Worst case I think they have store UTF8 in Latin1 format.
In my software I see é but in the DB I have é

Lot of fun if somebody have experience to share with me please let me know :smile:

Thanks!

2

There’s not a system wide solution for transforming decoding everywhere, but you can use OrmLiteConfig.StringFilter to inspect and filter fields from VARCHAR columns.

OrmLiteConfig.StringFilter = s => Decode(s);