| Bug #60652 | Query returns BLOB type but no BLOBs are in the database | ||
|---|---|---|---|
| Submitted: | 25 Mar 2011 21:09 | Modified: | 2 Jun 2011 18:21 |
| Reporter: | Matt Houser | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Connector / NET | Severity: | S1 (Critical) |
| Version: | 6.3.6 | OS: | Any |
| Assigned to: | Julio Casal | CPU Architecture: | Any |
| Tags: | BLOB, connector, NET | ||
If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.
To split a large file:
- On *nix platforms use the split command e.g.
split -b 50MB <my_large_archive> <my_split_archive_prefix> - On windows use WinZip or a similar utility to split the large file
[25 Mar 2011 21:10]
Matt Houser
[25 Mar 2011 21:10]
Matt Houser
Problem Query
Attachment: Problem.sql (application/octet-stream, text), 5.74 KiB.
[25 Mar 2011 21:10]
Matt Houser
Sample data
Attachment: InsertValues.sql (application/octet-stream, text), 520 bytes.
[27 Mar 2011 2:55]
Matt Houser
Workbench showing C15 as BLOB
Attachment: C15Blob.JPG (image/jpeg, text), 17.20 KiB.
[27 Mar 2011 3:10]
Matt Houser
Image showing expected bit data
Attachment: ShowingExpectedBit.jpg (image/jpeg, text), 54.12 KiB.
[27 Mar 2011 3:22]
Matt Houser
Error shown when performing the problem query using Connector/NET
Attachment: InvalidCastError.JPG (image/jpeg, text), 35.77 KiB.
[27 Mar 2011 3:38]
Matt Houser
Image showing data at time of error using Connector/NET. Datatype is "BLOB".
Attachment: ShowingBlobResult.jpg (image/jpeg, text), 55.47 KiB.
[23 May 2011 19:51]
Matt Houser
Sample application using Connector/NET
Attachment: EFTest3-TestApp.zip (application/x-zip-compressed, text), 90.75 KiB.
