Incorrect string value: ‘\xEF\xBF\xBD’ for column

\xEF\xBF\xBD is the UTF-8 encoding for the unicode character U+FFFD. This is a special character, also known as the “Replacement character”. A quote from the wikipedia page about the special unicode characters:

The replacement character � (often a black diamond with a white question mark) is a symbol found in the Unicode standard at codepoint U+FFFD in the Specials table. It is used to indicate problems when a system is not able to decode a stream of data to a correct symbol. It is most commonly seen when a font does not contain a character, but is also seen when the data is invalid and does not match any character:

So it looks like your data source contains corrupted data. It is also possible that you try to read the data using the wrong encoding. Where do the lines come from?

If you can’t fix the data, and your input indeed contains invalid characters, you could just remove the replacement characters:

lines[n] = lines[n].Replace("\xFFFD", "");

Related Posts:

  1. Configuration System Failed to Initialize
  2. Export Pervasive to MySQL (C#)
  3. Unable to connect to any of the specified mysql hosts. C# MySQL
  4. ImageMagick creating blank transparent square(s) according to width
  5. Why has the int32 type a maximum value of 2³¹ − 1? [duplicate]
  6. What is a PDB file?
  7. C# error: “An object reference is required for the non-static field, method, or property”
  8. Error : Could not load file or assembly or one of it’s dependencies
  9. C# compiler error: “not all code paths return a value”
  10. Algorithms in O(n^2) vs O(n) [duplicate]
  11. C# equivalent of C++ map
  12. The remote certificate is invalid according to the validation procedure [duplicate]
  13. WCF vs ASP.NET Web API
  14. The located assembly’s manifest definition does not match the assembly reference
  15. OnTriggerEnter not working at Unity3D
  16. Compiler Error Message: The compiler failed with error code -2146232576
  17. The requested resource does not support HTTP method ‘GET’
  18. Validation failed for one or more entities. See ‘EntityValidationErrors’ property for more details
  19. A generic error occurred in GDI+, JPEG Image to MemoryStream
  20. “Could not find a part of the path” error message
  21. WebForms UnobtrusiveValidationMode requires a ScriptResourceMapping for jquery
  22. What does the %= operator do? [duplicate]
  23. What does vary:accept-encoding mean?
  24. what is this oleaut32.dll?
  25. Why not use Html.EditorForModel()
  26. What is and how to fix System.TypeInitializationException error?
  27. How to move 2D Object with WASD in Unity
  28. The Object you want to instantiate is null. Unity 3D
  29. Convert date yyyyMMdd to system.datetime format
  30. How to bind a model to a kendo Combobox in order to use the models validatation?
  31. HttpWebRequest-The remote server returned an error: (400) Bad Request
  32. MSHTML DLL on Windows 10
  33. Adding values to a C# array
  34. What does {0} mean when found in a string in C#?
  35. How to use html.ValidationMessageFor
  36. EF 5 Enable-Migrations : No context type was found in the assembly
  37. What does the @ symbol before a variable name mean in C#?
  38. What is the C# version of VB.net’s InputDialog?
  39. Visual studio 2019 freezes when debugging
  40. How to make an HTTP POST web request
  41. How to add comments into a Xaml file in WPF?
  42. Are 2 dimensional Lists possible in c#?
  43. Passing just a type as a parameter in C#
  44. How to stop C# console applications from closing automatically? [duplicate]
  45. Can I send SMS Messages from a C# Application?
  46. How do you sort a dictionary by value?
  47. EntityType has no key defined error
  48. Expression denotes a `type’, where a `variable’, `value’ or `method group’ was expected UNITY3D
  49. How do I restart my C# WinForm Application?
  50. regular expression “.*[^a-zA-Z0-9_].*”
  51. Sharing violation IOException while reading and writing to file C#
  52. How to delete object?
  53. WSACancelBlockingCall exception
  54. Carriage return and Line feed… Are both required in C#?
  55. Inconsistent Accessibility: Parameter type is less accessible than method
  56. How to get correct timestamp in C#
  57. Cannot implicitly convert type ‘int’ to ‘string’ C# class
  58. If a folder does not exist, create it
  59. C# “No suitable method found to override.” — but there is one
  60. Fastest way to remove first char in a String
  61. System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
  62. What is the purpose of global.asax in asp.net
  63. How to convert datetime format to date format in crystal report using C#?
  64. How to add a string to a string[] array? There’s no .Add function
  65. How to block until an event is fired in c#
  66. How to use WPF Background Worker
  67. Case insensitive ‘Contains(string)’
  68. How to catch all exceptions in c# using try and catch?
  69. Getting “Handshake failed…unexpected packet format” when using WebClient.UploadFile() with “https” when the server has a valid SSL certificate
  70. Most efficient way to remove special characters from string
  71. Receiving access denied error from Visual Studio when trying to change target framework
  72. How to force garbage collector to run?
  73. Page vs Window in WPF?
  74. CS1617: Invalid option ‘6’ for /langversion; must be ISO-1, ISO-2, 3, 4, 5 or Default
  75. Sort list by field (C#)
  76. How to post data to specific URL using WebClient in C#
  77. Value does not fall within the expected range
  78. The type or namespace name could not be found
  79. How to execute a stored procedure within C# program
  80. The remote server returned an error: (405) Method Not Allowed. WCF REST Service
  81. TTS Voices for Windows7 64 bits
  82. How to play a sound in C#, .NET
  83. How can I delete a file that is in use by another process?
  84. Convert SQL to LINQ Query
  85. How to resolve file being used by another process?
  86. How to crop an image using C#?
  87. Convert double to float by cast or Convert.ToSingle()?
  88. Call a stored procedure with parameter in c#
  89. Type Checking: typeof, GetType, or is?
  90. C# Macro definitions in Preprocessor
  91. Adding images to buttons from Imagelist on a toolstrip?
  92. Multiple cases in switch statement
  93. System.ArgumentNullException: Value cannot be null. Parameter name: source
  94. Sequence contains more than one element
  95. Drawing circles with System.Drawing
  96. Parser Error Message: Could not load type ‘sometype’
  97. Func vs. Action vs. Predicate [duplicate]
  98. Cannot declare instance members in a static class in C#
  99. the source file is different from when the module was built
  100. How to set session timeout in web.config

Leave a Comment