title: Store and retrieve rtf character codes into sql database
body: <p>how can I retrieve the character codes when datatype is varbinary. It only gave the "System.Byte[]" string. Here is my code:</p>
  
  <pre><code>    public String getTextText(string name)
      {
          DataTable myData = new DataTable();
          SQLiteCommand cmd;
          SQLiteDataAdapter adptr = new SQLiteDataAdapter(); ;
          SQLiteConnection con = new SQLiteConnection("Data Source=database.db;Version=3;New=False;Compress=True;");
          con.Open();
          cmd = con.CreateCommand();
          string sql = "SELECT * FROM parent where name ='" + name + "' ";
          cmd.CommandText = sql;
          adptr.SelectCommand = cmd;
          adptr.Fill(myData);
          con.Close();
          return myData.Rows[0][1].ToString();
      }
  </code></pre>