Storing Serialized objects in MS SQL Server 2005

I have an object (which contains other objects) which I have been able to serialize and de-serialize.

I am in the process of considering of storing it in a MS SQL Server 2005 database.

I am a newbie when it comes to databases, and I wanted to know if the size of each serialized object that I want to store in the database is too big? Each object is about 10 to 50 MB?

Will that be possible? Thanks everyone.
yaronusaAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
yes. depending on what exactly is to be serialized, a VARCHAR or NVARCHAR could do the same job, but only if there are no non-character values to be serialized.
the VARBINARY data type has the advantage that it won't do any implicit changes to the data stream, like varchar/nvarchar might do for special characters, depending on the client's character set for example
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
the VARBINARY field can, in sql 2005, store up to 2GB ...
0
 
yaronusaAuthor Commented:
And would I be correct to assume that a serialized object be inserted into a VARBINARY field? Just making sure...
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
yaronusaAuthor Commented:
So if I don't have any char types in my C# object, I'll be good to go? Is that what you mean by "non-character" values? Sorry if this is a dumb question :)  ...
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
in short:
dates, numbers (except float) and textual values are character data.
images, files are non-character data
0
 
yaronusaAuthor Commented:
Thanks all!
0
 
mattphungCommented:
Angelll,

can you take a look at my question. I am trying to write/get the object from the database

I'm trying to retreive data from a varbinary field in SQL 2005
ID: 24592601
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.