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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-01 : 23:28:29
|
| durga writes "what is the maximum size of the image that i can store in sql datbase in image data type?Why i am asking this question is. I wrote a program in java that will send an image from client matchine to database in binary format and get back the same image when use click on the corresponding image name. Now what is my problem is that i am able to send the images of size up to 2kb only. I am sending my image to database useing byte array and getting also usig byte array onlythank u" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-01-01 : 23:42:55
|
| HiA VERY quick check of Books Online reveals that the size for the image data type is 2,147,483,647 bytes.But basically.....don't store images in SQL Server. Filesystems are much better for this.Damian |
 |
|
|
|
|
|
sql sever 2000