blob unload, dbexport
Posted in 2000
Topics: Storage & Space Management, Migration, Import/Export & Data Conversion
Blobspace was created.
The table was created:
CREATE TABLE photo (
photo BYTE in "blobspace",
name TEXT in "blobspace"
)
Any actions with the table (Select, Insert) work,
but when we use the following state (string):
unload to 'c:\\out.out' select * from photo
not all the data from blob-fields are being written into the file,that is the file is much of smaller size than it should be.
And when we use LOAD the data disappear.
What we should do in order not to lose binary data?
We have the same problem working with DBEXPORT.
It is remarked that if the data size in the table is less than 10 K,
that the file is not being cut (when we use UNLOAD).
The example of the exported table:
photo00143.unl
1|FFD8FFE000104A46494600010201004800480000FFED10C6506
4A464946 = jfif == the header jpeg
but the length of the whole string is 2200 symbols,
that is a approximately 1000 byte in blob
(because 255 = FF (1 byte in the database is approximately equal
to 2 bytes in the file .unl)), but the length should be 100*2 Kb.
The same with blob field in dbspace.
Changing of version Informix 7.3 to 9.2 doesn't help.
What is the solution of this problem?
Thank you.