title: Row too big to fit into Cursor window
body: <p>I'm storing a PNG file that is converted into a bitmap that gets converted into Byte[] and stored MySQL database. </p>
  
  <p>When I try and call an Item in the database I get the following error.</p>
  
  <blockquote>
    <p>E/SQLiteQuery: exception: Row too big to fit into CursorWindow requiredPos=0, totalRows=1; query: SELECT * FROM myTable</p>
    
    <p>Caused by: android.database.sqlite.SQLiteBlobTooBigException: Row too big to fit into CursorWindow requiredPos=0, totalRows=1</p>
  </blockquote>
  
  <p>Is there a way to increase the size of the Cursor window to accept the byte[]?</p>
  
  <pre><code>@Dao
  public interface MyDAO {
  
      @Query("SELECT * FROM myTable")
      LiveData&lt;List&lt;MyEntity&gt;&gt;getAllImages();
  </code></pre>
  
  <pre><code>public class MyRepository {
  
      private MyDAO mMyDao;
      private LiveData&lt;List&lt;MyEntity&gt;&gt; mList;
  
      public MyRepository(Application application) {
          MyDatabase db = MyDatabase.getInstance(application);
          this.mMyDao = db.mMyDao();
          mList = mMyDao.getAllImages();
      }
  
      public LiveData&lt;List&lt;MyEntity&gt;&gt; getAllImages(){
          return mList;
      }
  
  </code></pre>
  
  <pre><code>import java.util.List;
  
  public class MainViewModel extends AndroidViewModel {
  
      private MyRepository mRepository;
      private LiveData&lt;List&lt;MyEntity&gt;&gt; mList;
  
      public MainViewModel(Application application) {
          super(application);
          mRepository = new MyRepository(application);
          mList = mRepository.getAllImages();
      }
  
      public LiveData&lt;List&lt;MyEntity&gt;&gt; getList() {
          return mList;
      }
  </code></pre>
  
  <pre><code>public class MainActivity extends AppCompatActivity {
  
      @Override
      protected void onCreate(Bundle savedInstanceState) {
          super.onCreate(savedInstanceState);
          setContentView(R.layout.activity_main);
  
          final MainViewModel myViewModel = ViewModelProviders.of(this).get(MainViewModel.class);
  
  
          Button btnLog = findViewById(R.id.btn_log);
          btnLog.setOnClickListener(new View.OnClickListener() {
              @Override
              public void onClick(View view) {
                  Log.d("MyLog", "update Log");
                  myViewModel.getList().observe(MainActivity.this, new Observer&lt;List&lt;MyEntity&gt;&gt;() {
                      @Override
                      public void onChanged(List&lt;MyEntity&gt; myEntities) {
  
                          int listSize = myEntities.size();
                          Log.d("MyLog", "LiseSize " + listSize);
                          for(int i = 0; i &lt; listSize; i++) {
                              Log.d("MyLog", "MyID " + myEntities.get(i).getID() +
                                      ", bitmap " + myEntities.get(i).getPHOTO());
                          }
                      }
                  });
              }
          });
  </code></pre>
  
  <p>I was expecting to see the byte[] in the log cat</p>