Responding to myself.

Change charset to NONE in client connection and will be fine.

2010/11/4 hamacker <sirhamacker@...>:

> Hi everybody,
>
> I have a database that runs fine, but some SPs I can not view source
> code or edit, if I try then error message appear :
> Error : Cannot transliterate character between character sets.
> I try some clients as ibexpert and flamerobin and I receive the same
> error when I try to edit or view SP source code.
>
> I try using SQL also :
> select rdb$procedure_SOURCE from rdb$procedures
> where rdb$procedure_name = 'SP_NAME'
>
> But the same error again.
>
> I try backup and go fine, but when I try to restore, it's fail when
> arrives SPs [problematic].
>
> This SP does not corrupted because I can try exec SP and runs fine,
> just I can not edit.
>
> I have a backup of DDL of all objects, but I need to know if exists a
> solution to extract meta-data from this problematics objects;
>
> Any help will be welcome.
>
> H.
>