Firebird 2.5 CHARACTER SET WIN1252 is not installed

firebird freebsd firebird2.5
leonardorame picture leonardorame · Jun 28, 2013 · Viewed 9k times · Source

I've installed Firebird-Server 2.5 on FreeBsd 9.1 using:

pkg install firebird-server-2.5.2_1

It's working ok, since I can connect using FlameRobin from an external PC.

Now, when I try to restore a database using gbak, I got this:

...
gbak: ERROR:    CHARACTER SET WIN1252 is not installed
gbak:Exiting before completion due to errors

Should I install something more server side?. The database was created on a Windows machine, that's why its character set is WIN1252.

EDIT: after some trouble I deinstalled firebird and reinstalled WITHOUT USING SUDO.

Now I can connect using isql-fb and do "show system collation;". Here's 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.

Answer

TPAKTOPA picture TPAKTOPA · Dec 16, 2013

You have no access to intl subfolder. Few reasons:

  • You dont have right to access it ( mostly on linux/unix OS )
  • using embedded fbembed.dll without copy of intl subfolder
  • something wrong with your path, and Firebird fails to find intl subfolder

Most of these causes can be fixed by simple reinstalling server. If it's embedded , then you only need to copy intl folder , where fbembed.dll exists

Related questions

Generate insert SQL statements from a CSV file

I need to import a csv file into Firebird and I've spent a couple of hours trying out some tools and none fit my needs. The main problem is that all the tools I've been trying like EMS Data Import …

Read More
Firebird error "username and password are not defined" with Delphi application

I have an application made with Delphi 2006 and Firebird 2.5. For connection a use Interbase components from Delphi. I setting up in design time a TIBDatabase with username, password tc, and work ok, but when i want to run application in …

Read More
Firebird x Windows 7 x gds32.dll error

I have a fdb file (firebird) from a new client (he doesn't know the version). I have tried to use some GUI to access the database, but with no luck. All of them tell that its missing gds32.dll, but …

Read More