Subject Re: [firebird-support] CHARACTER SET WIN1252 is not installed
Author Mark Rotteveel
On Thu, 27 Jun 2013 17:56:30 -0300, Leonardo M. Ramé <l.rame@...>
wrote:
> On 2013-06-27 14:21:15 -0300, Leonardo M. Ramé wrote:
>> Hi, I've updated Firebird 2.5 on a FreeBsd 9.1 server. Usually I
restore
>> my databases using:
>>
>> gbak -c -v -REP -user USER -password PASSWORD bkp.ib database
>>
>> But, after the upgrade I'm getting this:
>>
>> gbak:restoring.................
>> ...............................
>> gbak: committing metadata
>> gbak: ERROR:unsuccessful metadata update
>> gbak: ERROR: TABLE
>> gbak: ERROR: CHARACTER SET WIN1252 is not installed
>> gbak:Exiting before completion due to errors
>>
>> Why CHARACTER SER WIN1252 is not installed? how can I install it?.
>>
>
> More info. Deinstalled everything and installed it again using:
>
> sudo pkg install firebird-server-2.5.2_1
>
> I noted the file /usr/local/etc/firebird/fbintl.conf contains info about
> character sets.
>
> This file has the lines:
>
> <intl_module fbintl>
> filename $(this)/intl
> icu_versions default
> </intl_module>
>
> Where the variable "$(this)" is pointing?. I have the fbintl in the
> directory /usr/local/libexec/firebird/intl owned by "root". Is this
> correct?, I've tested changing it to firebird:firebird, but the errror
> still persists.
>
> BTW, I can connect to databases without problems. The only thing I can't
> do is restore this database.

What do you see if you start ISQL and execute:
show system collation;