Convert formatted text in sqlite

See more:

C#

Edited.... Since I am writing this from my phone I want to make sure it's clear enough. All I really am requesting is what is the best way to keep the integrity of formatted text into a database then when I do a select statement it keeps the same format as it was before I updated the database. Would encrypting it or hashing it do the trick?



What would be the best way to hold large amount of formatted text in a database without losing the text format?

What I want to do is store code (like copy all code from a .CS file) and save it in a database. Then I want to do a select statement and write it to a text file where the format is still the same.


For example....if I have....

[code]

using System;  
using System.IO;  
  
class TexFileSample  
{  
    public static void Main()   
    {  
          
        using (StreamWriter sw = new StreamWriter(@"C:\SomeTextFile.txt"))   
        {             
            sw.Write("Writing Text ");  
            sw.WriteLine("Here we go.");  
            sw.WriteLine("-------------------");  
            sw.Write("Today is is: " + DateTime.Now);  
            sw.WriteLine("Done");  
        }  
    }  
}  

[/code]

And I want to insert this into a database I can pretty much copy and paste into a table, but that doesn't seem like the best logical way. So when I do a select statement and bring it back out I want the code block to look exactly as it was before going into the database.

I was thinking it should be hashed or encrypted or something, but not sure what I should do.

Any suggestions?

What I have tried:

Read a lot and searched for best way.