Michael Scholz wrote:
Hello,You don't explain how you stored or retrieved the blob.
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
If you inserted it as a string you need to properly quote the string before insertion.
If you are retrieving it into a string, you are out of luck, as most languages use 0x00 as an end of string.
If you are reading the blob into a file, it may be the viewer that is truncating the output, not MySQL.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
