The users are entering data in different fonts(most probably by copy-pasting data with fonts) but I want to store them as regular data. My column type is nvarchar
.
The data appears like this:
ᴩᴀᴅᴍᴀᴍᴍᴀ ᴛ
And if I query on ColumnName == ""
, it return these with empty strings.
How can I save them and read them as normal SQL text?
Steps to reproduce : Insert some text having font to a nvarchar column.
C_User user;
user = new C_User
{
Name = input.FirstName + (string.IsNullOrEmpty(input.LastName) ? "" : " " + input.LastName),
EntityType = typeof(C_Patient).Name
};
context.C_User.Add(user);