Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shapper
Constraint Violating Yak Guru
450 Posts |
 Posted - 2007-02-28 : 06:36:34
|
| Hello,I am working on a .NET project where I need to save classes to an SQL 2005 table. For that I am using Serialization.I need to decide what kind of serialization should I use:Binary or XML?And what SQL data type should I use?VARBINARY(MAX) > For binary serialization? I think Image should not be used in SQL 2005NVARCHAR(MAX) > For XML serialization?XML > For XML serialization?Thanks,Miguel |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
shapper
Constraint Violating Yak Guru
450 Posts |
Posted - 2007-02-28 : 07:23:43
|
quote:
Originally posted by Peso
Haven't we done this before?http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79760
Hi Peter,Not really. I read all those articles and they were useful.Usually image type is used for serialization. For example in Asp.Net 2.0 profile tables.However, I read somewhere that some data types shouldn't be used in SQL 2005 such as:IMAGE replaced by VARBINARY(MAX) > Don't know why is used in ProfileTEXT replaced by VARCHAR(MAX)NTEXT replaced by NVARCHAR(MAX)So I suppose I should use VARBINARY(MAX) for binary serialization and NVARCHAR(MAX) for XML serialization.And what is XML data type for?In case of serialization, what is the difference between NVARCHAR(MAX) and XML?I wrote this post so I could receive some confirmation on this.Thank You,Miguel |
 |
|
|
|
|
|
Serialization and DataType