Subject FB 2.1 Metadata Upgrade Failure
Author gorepj
I am experiencing some difficulty updating the metadata to FB2.1.

My DB has two tables with associated descriptions containing the
pound sign £, and some triggers that have embedded comments
containing non-ASCII letters.

I attempted to use the suggested metadata upgrade process and here's
my findings.

~~~~~~~~~~~~~~~~~~~~~~~~~~
Firebird correction text

Creating the procedures in the database
---------------------------------------
- 1. isql database.fdb
- 2. SQL> input 'misc/upgrade/metadata_charset_create.sql';
Should be
- 2. SQL> input '../misc/upgrade/metadata_charset_create.sql';

Fixing the metadata
-------------------
- 1. isql database.fdb
- 2. SQL> input 'misc/upgrade/metadata_charset_create.sql';
- 3. SQL> select * from rdb$fix_metadata('WIN1252'); -- replace
WIN1252 by your charset
- 4. SQL> commit;

Point 2 as above.
Point 3 executes OK
Point 4 fails for me. I get error `attempt to update read only
column'.
~~~~~~~~~~~~~~~~~~~~~~~~~
Regards
Peter Gore