Showing posts with label content. Show all posts
Showing posts with label content. Show all posts

Friday, February 17, 2012

Data Type > Save various object types

Hello,

I am working on a .NET project and I would like to save some LOCALIZED content in an SQL 2005 database.

This content might be a string, a number or even a class with its properties values defined so I can retrieve it later.

I will not need search or any complex operation just the following:
1. Add content to the database
2. Remove content from the database by contentId
3. Get content from the database by contentId

Anyway, is this possible?

What SQL 2005 datatype should I use to accomplish this?

Thanks,
Miguel

I suppose the only one which will work for you isvarbinary(max) I suppose

Thanks

Data type

I`m creating a database which will be use to store huge news data. Whatis the perfect data type for the news content, because I`ve tried allthe data types but they can`t store very long news. Thank you very much.
The Text data type will do what you are looking to do.