Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

BLOB declaring

Posted on 1998-10-20
5
197 Views
Last Modified: 2011-10-03
I want to declare a blob field and well I plan to use it
but I first need to initialize it and then be able to just take the information out of it in VBsript, my question is what do I declare it as..I want it an a field of a table...
Please Help ASAP
0
Comment
Question by:chicabow
  • 3
  • 2
5 Comments
 
LVL 1

Author Comment

by:chicabow
ID: 1090691
Any extra detail that I should be made aware of please let me know!  ASAP
0
 
LVL 7

Expert Comment

by:spiridonov
ID: 1090692
Your should declare the field as image datatype which is used to store biniary data up to 2Gb
0
 
LVL 1

Author Comment

by:chicabow
ID: 1090693
This needs to be a bit more descriptive...
like it will not work I tried that...
give me an example...
This is what I put and does not work...

creat table xxxx(one int,
                 two varchar(10),
                 subject dataype)


Please help more specifically.
0
 
LVL 7

Accepted Solution

by:
spiridonov earned 20 total points
ID: 1090694
You should have done:
creat table xxxx(one int,
                      two varchar(10),
                      subject IMAGE)
0
 
LVL 1

Author Comment

by:chicabow
ID: 2167435
But that does not work because it gives me an error when I try to insert text

Operand type clash: text is incompatible with image


I need to put text in there...

I will award the more points...
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

838 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question