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
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);