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 |
|
amit_gtbit
Starting Member
3 Posts |
 Posted - 2007-08-16 : 10:38:39
|
| pls. Help!I am not getting that how to use the image datatype in sql server 2000when i am inserting text to it and on retrieving it is showing hexadecimal string ...I want to know all of your views on the usage of image datatype..Thanks... |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-16 : 11:17:08
|
| image datatype is used to store binary data.for large text use varchar(8000) or text datatype._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
amit_gtbit
Starting Member
3 Posts |
Posted - 2007-08-16 : 15:16:26
|
| But i want to know that what is the purpose of introducing image datatype.Their should be some history for it's name as image because if store the name of the image in the database that doesn't provide security to the image data so,how it enforces security of Data.....pls reply .... and clear my doubts....... thanks |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-16 : 15:38:17
|
| i'm not quite sure what you're asking.the name "image" probably came from sybase's predecessor to sql server (i could be wring here)do not relate Image datatype with storing pictures in the database.you can save any kind of file in the Image datatype. audio, image, zip... anything that can be converted to binary.what problem are you having exactly?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-16 : 15:41:53
|
IMAGE datatype can be used to store large binary data of sizes greater than 8000 bytes, things you can't store with the TEXT datatype such as CHAR(0).
E 12°55'05.25"N 56°04'39.16" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Image Data Type