P
Perl Lover
Hi,
I am currently writing a perl dbi script to copy data from one rdbms to another.
One of the columns contain binary data. When I copy the data directly (reading
it from source, feeding it to target), it works fine. However when I save the
source data first in a file and then use that file to load it to the target it
messes up the binary data.
The source data is read via dbi cal fetchrow_array and the array is joined into
a string which is then print FILE to the file.
Am I doing something wrong here. Is there a better way to store the data without
using print, which does not corrupt the data.
thanks.
I am currently writing a perl dbi script to copy data from one rdbms to another.
One of the columns contain binary data. When I copy the data directly (reading
it from source, feeding it to target), it works fine. However when I save the
source data first in a file and then use that file to load it to the target it
messes up the binary data.
The source data is read via dbi cal fetchrow_array and the array is joined into
a string which is then print FILE to the file.
Am I doing something wrong here. Is there a better way to store the data without
using print, which does not corrupt the data.
thanks.