Insert Special Characters Into Sql Server 2008 Database

The ' ' character cannot be included in a name. I use a log manager to log the error to SQL Server 2008 database. Of course, it will raise another error in the SQL Server because i

Solution 1:

This is because you are using a space in an XML name. Correct your XML code to not have spaces in any tag names, this isn't SQL Server 2008 specific.

Solution 2:

To get a column to handle special characters define it as a NVARCHAR instead of a VARCHAR.