I installed Firebird-Server 2.5 on FreeBsd 9.1 using:
pkg install firebird-server-2.5.2_1
It works fine, since I can connect using FlameRobin from an external PC.
Now, when I try to restore the database using gbak, I got the following:
... gbak: ERROR: CHARACTER SET WIN1252 is not installed gbak:Exiting before completion due to errors
Should I install something more on the server side ?. The database was created on a Windows computer, so its character set is WIN1252.
EDIT: after some problems, I removed firebird and reinstalled WITHOUT USING SUDO.
Now I can connect using isql-fb and run "show system collation;". Here is the result:
... TIS620_UNICODE, CHARACTER SET TIS620, PAD SPACE, SYSTEM UCS_BASIC, CHARACTER SET UTF8, PAD SPACE, SYSTEM UNICODE, CHARACTER SET UTF8, PAD SPACE, SYSTEM UNICODE_CI, CHARACTER SET UTF8, FROM EXTERNAL ('UNICODE'), PAD SPACE, CASE INSENSITIVE, SYSTEM UNICODE_CI_AI, CHARACTER SET UTF8, FROM EXTERNAL ('UNICODE'), PAD SPACE, CASE INSENSITIVE, ACCENT INSENSITIVE, SYSTEM UNICODE_FSS, CHARACTER SET UNICODE_FSS, PAD SPACE, SYSTEM UTF8, CHARACTER SET UTF8, PAD SPACE, SYSTEM WIN1250, CHARACTER SET WIN1250, PAD SPACE, SYSTEM WIN1251, CHARACTER SET WIN1251, PAD SPACE, SYSTEM WIN1251_UA, CHARACTER SET WIN1251, PAD SPACE, SYSTEM WIN1252, CHARACTER SET WIN1252, PAD SPACE, SYSTEM WIN1253, CHARACTER SET WIN1253, PAD SPACE, SYSTEM WIN1254, CHARACTER SET WIN1254, PAD SPACE, SYSTEM WIN1255, CHARACTER SET WIN1255, PAD SPACE, SYSTEM WIN1256, CHARACTER SET WIN1256, PAD SPACE, SYSTEM WIN1257, CHARACTER SET WIN1257, PAD SPACE, SYSTEM WIN1257_EE, CHARACTER SET WIN1257, PAD SPACE, SYSTEM WIN1257_LT, CHARACTER SET WIN1257, PAD SPACE, SYSTEM WIN1257_LV, CHARACTER SET WIN1257, PAD SPACE, SYSTEM WIN1258, CHARACTER SET WIN1258, PAD SPACE, SYSTEM WIN_CZ, CHARACTER SET WIN1250, PAD SPACE, CASE INSENSITIVE, SYSTEM WIN_CZ_CI_AI, CHARACTER SET WIN1250, PAD SPACE, CASE INSENSITIVE, ACCENT INSENSITIVE, SYSTEM WIN_PTBR, CHARACTER SET WIN1252, PAD SPACE, CASE INSENSITIVE, ACCENT INSENSITIVE, SYSTEM
... but using gbak, I still get the same error.