stefan_ssssmart escreveu:

> Adriano, thank you for your reply.
>
> The problem is that in my post I was just describing a test-case. In
> reality we are talking about 30 production databases each with around
> 3500 procedures and 1000 triggers.
>
> If I understood you well, you are proposing to drop and recreate all
> this procedures and triggers using a connection character set like
> ISO8859_1? I thought that the procedure rdb$fix_metadata would fix the
> problem?
>

This procedure fix it, but if you already run it, it already changed
metadata to UNICODE_FSS. If you run it again on a object not recreated
wrong it will convert UNICODE_FSS (thinking it's in, say, ISO8859_1) to
UNICODE_FSS.

Anyway, you're free to update the script to run only on the objects that
you want.

> Second I used the test-case that you can see below with Firebird 2.1.1
> on Windows and did not receive any error "Malformed string".

But I said that this is FB 2.5 behavior.


Adriano