By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,133 Members | 1,092 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,133 IT Pros & Developers. It's quick & easy.

The size of the image data type

P: n/a
I'm using ODBC to interface a Microsoft SQL Server 2000. One of the
operations involves placing files within BLOBs. I'm using the image
data type for this purpose. Most of the time this works okey, but when
trying to add a 21,3 MB file I get an error. The error code is 22001,
which means "String right-truncation". But why? Does this mean that
the field cannot accepts BLOBs with this size?
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
[posted and mailed, všnligen svara i nys]

Bj?rn Terje Svennes (sv*****@datec.no) writes:
I'm using ODBC to interface a Microsoft SQL Server 2000. One of the
operations involves placing files within BLOBs. I'm using the image
data type for this purpose. Most of the time this works okey, but when
trying to add a 21,3 MB file I get an error. The error code is 22001,
which means "String right-truncation". But why? Does this mean that
the field cannot accepts BLOBs with this size?


It is unclear which component is the source for the error, but I would
expect it to be the the SQL Server ODBC driver, since SQL Server, as far
as I know, has no limit, in the 20 MB range.

It could be that for large blobs, you cannot pass the entire blob in
one do, but you have to pass it in chunks. I don't have any experience
of passing BLOB data from ODBC, so I cannot say which exact functions
you should use, though.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.