Storing Binary Data

Question

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

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

Steve Jones - SSC Editor SSC Guru Points: 736617 More actions · Answer 1

Use the varbinary data type.

Steve Jones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

Jonathan SSC-Insane Points: 20427 More actions · Answer 2

You will probably need to use the image data type for mp3s.

--Jonathan

iadams SSCommitted Points: 1970 More actions · Answer 3

Thats what I figured, seems obvious enough.

Is this what Frank K. was refering to in an earlier, unrelated post?

Are their any tricks I need to know to make this work well?

Thanks

Isaiah

-Isaiah

Frank Kalis SSC Guru Points: 111183 More actions · Answer 4

Uff, when I first read use varbinary I was insecure as to what should be used.

Anyway, this is a link I post frequently

I'm doing this again now, because I want to take the chance to bring things into the right context.

The first time I became aware of this MS resource was when Dale Elizabeth Corey (DaleC) posted it here. So all credit belongs to her!

So, Dale, long time no see. Are you still out there?

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]