Hi,

The procedures were created using EMS SQL Manager. That program gives and error message too, something like "can't load stored procedures because can't transliterate between charsets" - I was just posting the FlameRobin error because I supposed more people were using it here.

Any other ideas? How could I fix the code of stored procs without having to drop and recompile them? (I have almost 100 of them, so I don't really fancy the idea)

Thanks!

----- Original Message -----
From: Bogusław Brandys
To: firebird-support@yahoogroups.com
Sent: Thursday, May 07, 2009 10:16 PM
Subject: Re: [firebird-support] Stored proc charset problem after DB backup/restore





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




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