This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 4%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
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?
@Juan Dent , Welcome to Microsoft Q&A, Could you tell me how do you define the related field in your database?
CREATE TABLE Doctors (
id_doctor INTEGER PRIMARY KEY AUTOINCREMENT
NOT NULL,
first_name TEXT COLLATE NOCASE
NOT NULL,
last_name TEXT NOT NULL,
fkey_specialty INTEGER NOT NULL,
FOREIGN KEY (
fkey_specialty
)
REFERENCES Specialties (id_specialty)
);
The related field is either first_name or last_name., both behave the same when dealing with non-ASCII characters
Thanks
I cannot reproduce this issue with default installation of Sqlite an ASP.NET Core MVC application.
I'm guessing there is something else going on with your application. How or where are you displaying the text?
I am writing spanish text in a MFC EditBox and reading its value into a CString. The letter ñ inside the CString has a value of 241. Then I convert from CString (which is a wide string) to 7 bit string by using this code:
// convert wstring to string
inline std::string to_string(const std::wstring& str, const std::locale& loc = std::locale{})
{
std::vector<char> buf(str.size());
std::use_facet<std::ctype<wchar_t>>(loc).narrow(str.data(), str.data() + str.size(), '?', buf.data());
return std::string(buf.data(), buf.size());
}
And when I inspect the returned string the value for the ñ is -15 (which is 241-256) -- its out of range for a 8 bit signed char (which is 7 bits + the sign bit)...
Inside the debugger ñ is well displayed as ñ. All seems to be okay but when I load the string in a .NET application, the character ñ value is 65533 and it does not display as ñ!!
So it is an encoding problem!!
Looking at the character map application that is part of Windows 10 Pro, I can verify that ñ has a value of 241 in the unicode character set as well as the DOS : United States character set which is also 241
you can try
Convert.ToBase64String(Encoding.UTF8.GetBytes(dirtyString)))
https://geeksarray.com/blog/using-fluent-api-in-efcore-code-first
I advice to you use entityframework and be careful your database column variable types.