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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 get image big than 4096 byte

Author  Topic 

itdonline
Starting Member

2 Posts

Posted - 2007-04-02 : 09:17:05
hi everybody!
i have problem, help me.
i have one field datatype is image with size more than 4096 byte, so i can read data and show on web page.
i try user set text size but don't it
somebody help me!!!
thanks!

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-04-02 : 09:44:19
no help possible with current provided info.
please specify your problem in greater detail.

Thank you for your cooperation.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

itdonline
Starting Member

2 Posts

Posted - 2007-04-02 : 22:41:35
i'm sorry i write wrong
i can not read full data from field with datatype is image big more than default value 4096.
please help me thanks
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-04-03 : 03:53:27
in sql server image doesn't have an upper boundry of 4096.
it's 2,147,483,647 bytes.

so are you sure this is sql serevr you're talking about?

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-04-03 : 03:57:46
It is probably the front-end limitation you are talking about. Where are you showing this data? Is this binary data like picture or textual data?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page
   

- Advertisement -