Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filling a database with files

Status
Not open for further replies.
Ramo83

Ramo83

Programmer
Apr 7, 2005
20
IE
Hello,
How can I fill a database with files (like mp3s or .jpeg)??
The thing that the database only support specific data types and it cant be filled by anything else...
Thank u
 
Sort by date Sort by votes
Depends on the specific DBMS. Most of them support a BLOB (Binary Large Object) data type (the names may be different) where you can store pretty much anything.
 
Upvote 0 Downvote
Ok I have SQL Server 2000.
I have files objects of type: FileInfo and I want to change (convert) the files to a binary objects...
How can that be done please??
Thank you
 
Upvote 0 Downvote
as this is a SQL Server question, and also it will depend on whether you use another programming language to do so I advise you to post this question on the SQL Server Forum first, and if you use VB on the VB forum instead.


Regards

Frederico Fonseca
SysSoft Integrated Ltd
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
212
carp
carp
BobThornton
  • Locked
  • Question
Count records until a record value changes
Replies
2
Views
357
carp
carp
mmiah1982
  • Locked
  • Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
203
mmiah1982
mmiah1982
fredong
  • Locked
  • Question
Update upper row data with next row data that was detached partially from import.
Replies
6
Views
262
carp
carp
BobThornton
  • Locked
  • Question
Cross Join in an Insert Into
Replies
1
Views
213
carp
carp

Part and Inventory Search

Sponsor

Back
Top