Subject Re: [firebird-support] Stored proc charset problem after DB backup/restore
Author Bogusław Brandys
Zd wrote:
>
>
>
> Dear group,
>
> I have a database with default charset set to ISO8859_2.
>
> Everything is fine till I backup and restore the database.
> After the restore, upon trying to load the code of some of the stored
> procedures that loaded normally before, I get the following error:
>
> ------------ --------- ------
> Unhandled Error in FlameRobin
> ------------ --------- ------
> *** IBPP::SQLException ***
> Context: Statement::Fetch
> Message: isc_dsql_fetch failed.
>
> SQL Message : -314
> Cannot transliterate character between character sets
>
> Engine Code : 335544565
> Engine Message :
> Cannot transliterate character between character sets
>
> Why does this happen? And why does it happen only after a restore?
>
> Thanks!
>

Maybe check Flamerobin character set setting ? I don't know that program
but imho client character set and database character set should somehow
coincide (not exact but related by allowed conversion routine)

Boguslaw