How to set text encoding on a data column from EntityFramework or ADO.NET?

Juan Dent 236 Reputation points
2022-08-30T21:17:29.73+00:00

I have a native C++ Windows MFC application that accesses sqlite3.dll to load data from a database and it loads non-ASCII characters like 'ñ' without changing them to '?'
When I access this database from EntityFramework, the non-ASCII characters get represented like '?' instead. Where can I configure EF or ADO.NET to correct this?

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
701 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,363 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Muhammed Şeker 76 Reputation points
    2022-09-05T10:42:45.207+00:00

    I advice to you use entityframework and be careful your database column variable types.

    0 comments No comments