Image data type 1

[Vivianez]

How can I use an image in a database?
Is it the same (insert, select....) as a char data type?

 

[NoCoolHandle]

No differently.. The trick is packaging the data with the client. In DotNet we use bytarrays in vb6 it was chunks or streams..

But the fundamental insert/update/delete/select statement is no different

 

[Vivianez]

Ok, Thanks!!!But could you give me an exemplo? I´m really confused.

 

[NoCoolHandle]

create table TableWithImages
(imagekey int identity primary key,
 picture image not null)
go

insert into image (picture)
select photo from northwind.dbo.employees 
go
select * from TableWithImages
go
update TableWithImages set picuter = (select picture from TableWithImages where imagekey = 3) where imageKey = 1
go
select * from tablewithimages
go

in a storedproc

create proc addimage
@photo  image
as
set nocount on
insert into TableWithImages (picture)
values(@photo)

That what you are looking for?

Rob

 

[Vivianez]

No, I want to know how can I store the .jpg in the database.
Maybe using Textcopy? Do I have the specify the location of the jpg? Where? How?

 

[NoCoolHandle]

there is NO direct support in SQL language for inserting a file from the hard drive...

i.e. You can't insert into TableWithImages values('c:\mypicutre.jpg')

don't work...

HOWEVER

with SQL there is a very nice commandline tool for doing exactly that..

it is called TextCopy.ext and can be found in the bin directory of SQLServer.

C:\>"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\textcopy.exe"/?
TEXTCOPY Version 1.0
DB-Library version 8.00.194

Copies a single text or image value into or out of SQL Server. The value
is a specified text or image 'column' of a single row (specified by the
"where clause") of the specified 'table'.

If the direction is IN (/I) then the data from the specified 'file' is
copied into SQL Server, replacing the existing text or image value. If the
direction is OUT (/O) then the text or image value is copied from
SQL Server into the specified 'file', replacing any existing file.

TEXTCOPY [/S [sqlserver]] [/U [login]] [/P [password]]
[/D [database]] [/T table] [/C column] [/W"where clause"]
[/F file] [{/I | /O}] [/K chunksize] [/Z] [/?]

/S sqlserver The SQL Server to connect to. If 'sqlserver' is not
specified, the local SQL Server is used.
/U login The login to connect with. If 'login' is not specified,
a trusted connection will be used.
/P password The password for 'login'. If 'password' is not
specified, a NULL password will be used.
/D database The database that contains the table with the text or
image data. If 'database' is not specified, the default
database of 'login' is used.
/T table The table that contains the text or image value.
/C column The text or image column of 'table'.
/W "where clause" A complete where clause (including the WHERE keyword)
that specifies a single row of 'table'.
/F file The file name.
/I Copy text or image value into SQL Server from 'file'.
/O Copy text or image value out of SQL Server into 'file'.
/K chunksize Size of the data transfer buffer in bytes. Minimum
value is 1024 bytes, default value is 4096 bytes.
/Z Display debug information while running.
/? Display this usage information and exit.

You will be prompted for any required options you did not specify.

 

[Vivianez]

Thanks! Now I know what to do.
Evething is clear now....