From: Adriano d. S. F. <adr...@uo...> - 2008-02-26 18:34:25
|
Peter Gore escreveu: > > 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'; > This depends on your working directory. > > > 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'. > Could you please send a reproducible test case (small db or backup) to me? Adriano |