If you ever store HTML or XML text in SQL Table ? Then in many scenarios you need to encode string before storing to database so when you display that text in browser it shows up correctly. Here is small snippet which can easily encode string using simple T-SQL technique.<\/p>\n
\r\nSELECT \r\n FIELD_NAME \r\n ,(SELECT FIELD_NAME AS [text()] FOR XML PATH('')) AS FIELD_NAME_HtmlENcoded \r\nFROM (SELECT '<HTML>Joe''s Pizza<\/HTML>' as FIELD_NAME ) TABLE_NAME\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"If you ever store HTML or XML text in SQL Table ? Then in many scenarios you need to encode string before storing to database so when you display that text in browser it shows up correctly. Here is small …<\/p>\n