Subject Re: [firebird-support] Re: Changing database locale
Author Pierre Y.
Hi,

You may have errors in your database, please check that gfix -validate -full
runs without errors and that you can backup/restore your database with gbak.

Next, You may have non WIN1251 data in some of your sub_type 1 blobs. It
would be useful to connect to source database using NONE character set.

And if nothing helps and you can send me a copy of your database, I would
give it a look asap (pierre.y@...)

Regards,

--
Pierre Y.
Author of FBClone ;-)

On Wed, May 19, 2010 at 11:17 AM, amacprogramming <amacprogramming@...
> wrote:

>
>
>
>
> --- In firebird-support@yahoogroups.com<firebird-support%40yahoogroups.com>,
> Philippe Makowski <makowski@...> wrote:
> >
> > > So what I would love to know is if I'm missing an easier way to do this
> or if it really is that complicated?
> > try this tool (fbclone) it was done for that also
> >
> > http://code.google.com/p/fbclone/
> >
>
> Thanks for the suggestions!
>
> I am now using fbclone, since it is exactly what I have been looking for.
> But troubles occured again.
>
> Some tables have BLOBs sub_type 1 and sub_type 0 these rows are not getting
> transfered with an error like this:
>
> ErrorCode = 62
> SQLCode = -901
> BLOB not found
>
> Any ideas for why this could happen in a cloning operation? I also tried
> the -po switch (pump data only) but that did not help either.
>
> So, any suggestions?
>
> Kind regards, Amac
>
>
>


[Non-text portions of this message have been removed]