Connection rejected: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding)

Question

When I try to connect to a Firebird database with dbeaver this error is shown:

Connection rejected: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding). Please specify a connection character set (eg property charSet=utf-8) or consult the Jaybird documentation for more information

Answer 1

Edit Connection -> Driver properties -> Add new property lc_ctype = .... (example WIN1252,UTF-8,UNICODE,...)

https://www.firebirdsql.org/file/community/ppts/fbcon11/FbCon2011-Charsets-Heymann.pdf

Answer 2

The error says you "Please specify a connection character set" - and that is what you have to do.

Open DBeaver configuration, find the connection string or how it is called in DBeaver, and add any one of the connection encoding parameters with the value you want to the connection URI you set in DBeaver.

See section 3.2 in the Jaybird FAQ:

Jaybird provides two connection properties to specify the connection character set:

• charSet with a Java character set name (alias: localEncoding)

  The Java character set name must map to an equivalent Firebird character set.

• encoding with a Firebird character set name (alias: encoding[sic, should be lc_ctype])

  The Firebird character set name - with the exception of NONE must map to an equivalent Java character set.

For most applications, use only one of these two properties.

For the specifics of this error see section 3.2.3 in the FAQ.

Answer 3

I had to install a past jaybird.jar version 2.2.13 of driver connection of Firebird to fix this problem.