Nick Upson wrote:

>>> Is anyone using fbcopy on tables that contain a blob, when I try it
>>> it fails complaining about a datatype mismatch.

Is it a BLOB column in both source and target database?
What is the character set?

>>> I have recompilied fbcopy with fb 2.1
>> Which version of FBCopy? Is blob sub_type 0 or 1?
>>
> the latest on I could find on sourceforge, 1.52

The latest version can be found here:

http://www.firebirdfaq.org/fbcopy.php

I have first wanted to merge project with fbutils.sf.net, then to move
it to firebirdfaq, so it's currently available on all 3 of those
websites, but versions are not in sync. I'll try to clean up this mess
soon once I decide the final place for these tools.

If you still have problems with the latest version, please let me know
and I'll test it.

--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com