Subject | Stored proc charset problem after DB backup/restore |
---|---|
Author | Zd |
Post date | 2009-05-07T11:24:25Z |
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!
[Non-text portions of this message have been removed]
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!
[Non-text portions of this message have been removed]