Commented by: Claudio Modanese (claudiosinesy)

Attached the DB to reproduce the error on the issue

Commented by: @dyemanov

Please try with the latest snapshot build of v2.1.4.

Commented by: Claudio Modanese (claudiosinesy)

I've try with v. 2.1.4... same error.

Commented by: @asfernandes

What application did you use to connect?

Are you *sure* the application works with actual UNICODE_FSS/UTF-8 data?

Commented by: Claudio Modanese (claudiosinesy)

I've try with EMS, FlameRobin and also an application that I've developped using IBO Objects.

Commented by: @asfernandes

Database has invalid unicode data.

Commented by: Claudio Modanese (claudiosinesy)

What does it mean "Database has invalid unicode data?"

The db attached was created with the following sql script:

CREATE DATABASE 'c:\database.gdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE = 1024
DEFAULT CHARACTER SET UNICODE_FSS

CREATE TABLE TABLE1 (
FIELD1 VARCHAR(50) CHARACTER SET UNICODE_FSS
COLLATE UNICODE_FSS
)

The following query give me the error:

select * from TABLE1 where field1 like 'ä'

Where is the error?

Commented by: Claudio Modanese (claudiosinesy)

Using firebird 1.5 the query will crash the fbserver.

Commented by: @asfernandes

Please ask in a support list about client character set and actual data encoding. They must match.