Subject | Re: [firebird-support] Re: migrate from firebird 1.5 32bit to firebird 2.5 64bit on linux |
---|---|
Author | Philippe Makowski |
Post date | 2011-01-14T07:45:10Z |
2011/1/14 Paul Vinkenoog <paul@...>
sorry Paul it will not help, if it was so easy, Firebird would deal
with it correctly, and we would not need -FIX...
> The thing is that you have to find out which charset is/was REALLY used for your database metadata, and use that as the argument of the -fix_fss_metadata parameter.;)
>
> Have a look at the system tables; maybe IBExpert will show you what the character set of the text columns is.
>
> Or run this query - in your Firebird 1.5 database, via a Firebird 1.5 server:
>
> select c.rdb$character_set_name
> from rdb$fields f
> join rdb$character_sets c
> on f.rdb$character_set_id = c.rdb$character_set_id
> where f.rdb$field_name in ('RDB$TRIGGER_NAME', 'RDB$TYPE_NAME', 'RDB$USER')
> and f.rdb$system_flag = 1
>
sorry Paul it will not help, if it was so easy, Firebird would deal
with it correctly, and we would not need -FIX...