Results 1 to 2 of 2

Thread: subset of BLOB

  1. #1
    Join Date
    Aug 2006
    Posts
    33

    Question Unanswered: subset of BLOB

    Hi there,

    I have a column which is byte(32375), my understanding is it is a blob with binary data. Since it only contains large text, my question is can I get a sub string of this column?

    Thanks,
    Jinse

  2. #2
    Join Date
    Aug 2005
    Posts
    140
    BLOB columns require special
    handling and so can only be handled in ESQL/C, ODBC, or 4GL programs which
    means that you cannot display a BLOB in dbaccess, perform, or ace. You
    also cannot include a BLOB in a where clause except as a substring
    expression.

    blobtable (one text)
    in dbaccess:
    select one[1,4] from blobtable
    ----------------------------------------------
    one
    Ahoj
    -------------------------------------------
    blobtable1(one byte)
    in dbaccess:
    select one[1,4] from blobtable1
    ------------------------------------------
    one <BYTE value>
    ------------------------------------------

    So it look like you can get a substring of you column whe you change it from
    byte to text ( TEXT and BYTE are actually
    treated the same by the engine)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •