Subject Re: Two problems: charsets and gbak
Author alex_vnru
--- In ib-support@y..., "Douglas Tosi" <douglasht@i...> wrote:
> Load an sql script in IBConsole
> If i run the same sql script on IBExpert, everything is fine.

Hi, Douglas. Being user of Classic server I can say nothing about
IBConsole, but have suspiction that it does'nt work with FB correctly.

> Connect to this restored database and I start receiving
> erros whenever I try to read values with non-low-ASCII chars.

Are you shure you specified charset for connection?

> Now I backup this database:
> gbak -b -v db2.gdb db2.gbk
> and try to restore it:
> gbak -c -v -p 8192 db.gbk db3.gdb
> and receive the following error:
> ERROR: attempt to store duplicate value (visible to active
transactions) in
> unique index "RDB$INDEX_11"

There was such a bug in gbak (or server, not shure) that was fixed.
I can't remember exactly in what build number. 608 and higher
certainly are not affected by this bug. Take fresh build and check
existance of line with "RDB$SECURITY" (Not "RDB$SECURITY_CLASS") in
the table RDB$GENERATORS in your database. If it exists, delete it
before backing up.

Best regards, Alexander V.Nevsky (Ded)