Post reply

BLOB datatype

  • May 11, 2004 at 10:07 am

    #179638

    Hello,

    Can someone tell me how to create a BLOB datatype in SQL Server 2000? 

    Is there other datatypes that can be used in conjunction with BLOB?

    Thank you,

    Pete.

    Peter M. Florenzano

    Database Administrator

  • May 11, 2004 at 11:14 am

    #506019

    In SQL Server, the datatype names are a bit different:

    BLOB = Image

    CLOB = Text or NText

    So, to create a BLOB:

    CREATE TABLE MyTable (MyBLOB image)

     

  • May 11, 2004 at 12:09 pm

    #506024

    Hi Brendthes,

    Thank you for your reply.  I will give this a try.

    Pete

    Peter M. Florenzano

    Database Administrator

  • December 29, 2011 at 8:18 am

    #1426461

    This is what I see in Select statment. It is SQL 2000. What this encryption holds is not necessary as it is used by JD Edward.

    ID Image

    F9801 0x030083FFD5D0803A6650000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

    I want to update few rows with Image datatype using T-SQL. Is there any way to writed Update statment and pass this value as varchar. I used below statment but it is not giving desired results at application level.

    UPDATE F980SEC

    Set Imange = '0x050085FFD5D0805A6650000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply