Results 1 to 4 of 4

Thread: Image Data Type

  1. #1
    Join Date
    Jul 2004
    Posts
    2

    Unanswered: Image Data Type

    I have a column that has audit details stored as an image data type. How do i convert that into meaningful data that i can read.
    Example:
    0x78F992BD69BF23BE243134839506265892223083981A6104 A389A1B1918129B6303035B434C7748FAF63508887A33B99CB AE4C8C4C8D71B68DCC8CCC8C0D4D71350040B246C603309AEE 1810E0EAE8437046C3C440D7C48892414E007B1F8BED
    I am guessing this is text with fomatting instructions. Because in the software that utilized this database, this field seems to be interpreted as a hierarachial table showing the audit details of an event.

    please offer any suggestions you can.
    thanks so much

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Actually this is binary data. The only way to access or read it is through an application. See www.asp.net for some examples of how to access the data.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  3. #3
    Join Date
    Jul 2004
    Posts
    2

    Another Question

    Is this a BLOB file that i can use a filestream object to import into a VB application? Sorry for my newbieness.

    thanks

    Mardi

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Yes, an IMAGE is a blob. Typically, it is at least an 8 kb blob in order to use the database space effectively, although it can be smaller.

    -PatP

Posting Permissions

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