Loading ...
Sorry, an error occurred while loading the content.

4878SQL Server 2012 Binary Text Field - convert to human readable HTML text

Expand Messages
  • Charles Carroll
    Feb 27 9:12 AM
    • 0 Attachment
      I inherited a lousy database - 2nd normal form max, no documentation, most things done wrong.

      HTML in the DB is stored in a text field

      a. why not varchar(max)? That is what I will change it to.

      The text field appears to be binary i.e.
      PEZPTlQgc2l6ZT0zPiAKPFA+VG9 ...

      What is easiest way to convert it to text again?

      I am in SQL Server 2012 who knows what DB version they made it in 12 years ago...
    • Show all 8 messages in this topic