It looks like an apostrophe, right? But it's not. Here's an apostrophe -> '
That special character is not on my keyboard and is pasted from Word.
I have a test DB with a test table with a single TEXT column called testtext. The following query runs without a hiccup (and the insert is performed):
(notice that special character in there)insert into test (testtext) values ('hey y’all');
However, the following code throws an exception at SaveChanges:
Code: Select all
var test = new test(); test.testtext = "hey y’all"; ent.tests.AddObject(test); ent.SaveChanges();
Stack trace:Incorrect string value: '\x92all' for column 'testtext' at row 1
I emailed support and haven't even received a response.at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)\r\n at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache)\r\n at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)\r\n at System.Data.Objects.ObjectContext.SaveChanges()\r\n ...