Posted on: 2/4/2012 9:59:56 PM | Views : 1065

Hi,
my application require me to save some HTML snippets into DB ( i am using SQL 2008 R2 express ) table which varchar max columns. A particular string is:
"...<span style='position:relative;top:3.0pt'> </span>..."
I wrote a program in c# which extract HTML snippets from the main html file. The program will create  a sqlcommand, pass in the html snippet as string into a stored procedure and execute the insert. In the C# program, the parameter of this field is declared as 'SqlDbType.VarChar' and in the stored procedure, this parameter is declared as 'varchar(max)'. I checked that just before the insert (eg. ExecuteNonQuery()) the html string is still fine ( a blank space in between the span tags ). 
However, when i checked the record in DB, i found that a '?' has replaced the blank between the span tags. 
"...<span style='position:relative;top:3.0pt'>?</span>..."
is there any ...

Go to the complete details ...