attachment in database

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • =?Utf-8?B?R3V5IENvaGVu?=
    #1

    attachment in database

    Hi all
    What is the correct field type in sql server 2005 for attachments?
    I used TEXT and tried to store a small jpg file (30KB).
    I got a run time error
    "Attempted to read or write protected memory"
    I tried to play with inserted value, when I insert there:
    ""
    or
    chr(1)
    or
    chr(1) & chr(0) & chr(1)
    There is no problem....

    Please advise -

    TIA
    Guy Cohen
    Tags: None
    • Spam Catcher
      #2
      Re: attachment in database

      =?Utf-8?B?R3V5IENvaGV u?= <GuyCohen@discu ssions.microsof t.comwrote in
      news:2F1F8DA8-606C-4BCA-BCD1-86255710D56B@mi crosoft.com:
      Hi all
      What is the correct field type in sql server 2005 for attachments?
      I used TEXT and tried to store a small jpg file (30KB).
      You can use the IMAGE data type (really a blob) or the new varbinary(max)
      in SQL Server 2005.



      --
      spamhoneypot@ro gers.com (Do not e-mail)

        Comment

        Previous template Next
        Working...