This is a migrated thread and some comments may be shown as answers.

serialized to blob

1 Answer 53 Views
Databases and Data Types
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
amir sherafatian
Top achievements
Rank 1
amir sherafatian asked on 29 Sep 2009, 10:39 AM

hi
i have a field of type byte[] , to mapp this field i select type Blob and varbinary(max) sql type
about the check box of serialize to blob,what is its benefit and harms??? and when it should be use ?

tanks

1 Answer, 1 is accepted

Sort by
0
Zoran
Telerik team
answered on 30 Sep 2009, 07:58 AM
Hi amir sherafatian,

The blob serialization should be used in cases when there is a field of a type which does not have a corresponding type in the database server( or the corresponding type is not supported by OpenAccess). Arrays as in your case are one of the typical examples of such fields. The benefit is that the field is stored in the same table as the other fields from the persistent type. Otherwise there would be an additional table required to store the array values. The disadvantage of course is that you can not build a query based on such field. There are no means of filtering or ordering your data by it.

All the best,
Zoran
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Tags
Databases and Data Types
Asked by
amir sherafatian
Top achievements
Rank 1
Answers by
Zoran
Telerik team
Share this question
or