You should first check the Database registration info at IbExpert,
especially the CharSet.

Paulo Botelho

----- Original Message -----
From: "zifnabbe" <zifnabbe@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, April 30, 2004 11:40 AM
Subject: [firebird-support] Re: Corrupt database


> When I iterate a through the PERSONS table (with IBExpert) I get at
> the certain moment the following error:
>
> Arithmic overflow of division by zero has occured
> arithmic exception, numeric overflow or string truncation
>
> Cannot transliterate character between character sets.
>
> Does this means that there is a strange character in a certain
> record? How can I find this record and fix or delete it?
>
> Thanks,
> Tom.
>
> --- In firebird-support@yahoogroups.com, "zifnabbe" <zifnabbe@u...>
> wrote:
> > Mmm,
> >
> > When I restore with -inactive. then I can activate all indexes
> except
> > on foreign:
> >
> > Cannot commit transaction:
> > violation of FOREIGN KEY constraint "".
> > violation of FOREIGN KEY constraint "PK_PERSONS" on table "PERSONS".
> >
> > How do I've to interprete this?
> >
> > Where can the problem be? at the persons table or the other one?
> >
> > Tom.
> >
> > --- In firebird-support@yahoogroups.com, "zifnabbe" <zifnabbe@u...>
> > wrote:
> > > Thanks all,
> > >
> > > When I follow the guidelines and try to restore the database,
> gbak
> > > ends with the following error:
> > >
> > > gbak: cannot commit index RDB$FOREIGN20
> > > gbak: ERROR: violation of FOREIGN KEY constraint "PK_PERSONS" on
> > > table "PERSONS"
> > >
> > > gbak: ERROR: action cancelled by trigger (3) to preserve data
> > > integrity
> > > gbak: ERROR: Cannot deactivate primary index
> > > gbak: Exiting before completion due to errors
> > >
> > > What can this be causing?
> > >
> > > Thanks,
> > > Tom.
> > > --- In firebird-support@yahoogroups.com, Helen Borrie
> > <helebor@t...>
> > > wrote:
> > > > At 12:56 PM 30/04/2004 +0000, you wrote:
> > > > > >
> > > > > > You should be able to fix these with gfix. There may be
> some
> > > lost
> > > > >data, however.
> > > > >
> > > > >how can I fix this with gfix? ie which command do I use for
> this?
> > > >
> > > > http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_db_corr
> > > >
> > > > /heLen
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>