retrieve data of longblob field

2004-03-31 Thread Michael Scholz
Hello,

i stored some files which containing some 0-bytes in longblob fields. If i try to 
select the files of these fields, i only get the bytes before the first 0-byte.
I tried this with some clients like MySQL-CC, MySQL-Front, AquaDataStudio and own 
java-clients. But it is always the same result.
What's the matter of this?

Thanks,

Michael Scholz

storing files in blob field

2004-03-30 Thread Michael Scholz
Hello,

i try to store some files into a blob-fields of a myisam-table at mysql 4.1.
If the file includes bytes with hex-value 00, mysql will only store the bytes before 
this ' 0-byte ' .
How can i store a file including bytes with value 00?

Thanks,

Michael Scholz