Any characters or string not accepted in MS SQL?
Posted on 2011-03-09
I have a text (an article in fact) that i want to insert into a column (text). I noticed that with the HTML tag (even with HTMLencode), the text will not be inserted to MS SQL.
However, with just a normal text (with all the HTML tag removed), it's able to be inserted.
Thus my question is that any char, string, text format that is not accepted in MS SQL? So that i can filter out these unacceptable combination prior to inserting.