View Single Post

   
  #1 (permalink)  
Old 02-29-2008, 02:16 PM
serge
 
Posts: n/a
Default Store Multi-Select values in an image data type?

I was working on figuring out where a certain application was
storing the multiple selection choices I was doing through the app.
I finally figured out that they were being store in an IMAGE
data type colum with the variable length of 26 bytes.

This is the first time I ran into such way of storing multiple
selections in a single Image data type.

Is this a better alternative than to store into a One-to-Many
tables? If so then I'll have to consider using the Image data
type approach next time I have to do something like storing
1 to thousands of selections.

Thank you


Reply With Quote