Platform

Flamerobin: Version 0.9.3 - e601534 (64 bit)
OS: Windows 10 - (64 bit)
FireBird: Version 4.0.1.2692 (64 bit) - This problem is also with FireBird 3.0.9

Description

When a new (derived) collation is created from existing collation and it is set as a default collation for a character set then
FlameRobin has problems.

Steps to reproduce

1. Create a database with default character set as ISO8859_1
   

2. Creating a case-insensitive collation based on an already existing collation in the database
   CREATE COLLATION EN_US_CI_AI
   FOR ISO8859_1
   FROM EN_US
   NO PAD
   CASE INSENSITIVE
   ACCENT INSENSITIVE;

3. Set created collation as default for ISO8859_1
   ALTER CHARACTER SET ISO8859_1 SET DEFAULT COLLATION EN_US_CI_AI;

4. Create a table normally
   CREATE TABLE Contacts
   (
   ContactPK INT not null,
   ContactName VARCHAR(20) not null
   );

Problems

Column Data Types are not displayed in Tree View, Properties page & DDL. Instead of column data type, RDB$1 / RDB$2 is displayed.

Select query and Browse Data does not work on System Tables. Flamerobin hangs/crashes after selecting Yes or No on the error message box.

Workaround Solution

While connecting to database if UTF8 is selected in character set then above problems are not found.