Post reply

Saving Formatted text in a SQL field

  • March 14, 2005 at 7:56 am

    #85631

    I am wondering if their is any way of saving formatted text in a sql table field, or is the only way to save formated text is in a table with a pointer to another file.  I was wondering if i used that method how would i get the text out of the text file an in to my reports or forms.  Any help would be greatly appreciated.

  • March 14, 2005 at 9:59 am

    #546888

    HTML is the most obvious method that I know of to encode text formatting. So, convert your files to HTML and you can store them in a CHAR/VARCHAR/TEXT field in SQL Server.

    Even better, if you are using SQL Server 2005 Beta (which I imagine you are because this is a SQL Server 2005 forum) you could make sure that the HTML is well formed and store it in a field of type XML.

    Hope that helps.

     

    Jamie Thomson
    http://sqlblog.com/blogs/jamie_thomson

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply