title: How to create a table with a BLOB datatype column in informix?
body: <p>I am going to create a table in a informix database whcih is with a BLOB data typed column.It is going to save a image data. Here is my syntax as follows.</p>
  
  <pre><code>create table blob_test_db
    (
      col1 varchar(10),
      img_bin BLOB in blob_dbspace
    ) extent size 32 next size 32 lock mode page;
  </code></pre>
  
  <p>According to my above syntax I want to store my <code>img_bin</code> data in <code>blob_dbspace</code> dbspace. I want to know is it possible? However above syntax is wrong. Please tell me the correct syntax for adding blob type column to the informix table.</p>