Does FlameRobin have problems with the insertion of umlauts?

Question

I have a table with a field

VALCONTENT BLOB SUB_TYPE TEXT SEGMENT SIZE 80

When I browse the table, right click on an entry, select "Edit blob" the content is shown.

If I enter "normal" test ("Hello world"), I can click "Save" and things work.

If I use umlauts ("Hällö Wörld"), I get an error message:

IBPP::SQLExcetption, Contenten: Statement: Execure (Update MyTable set foo= ? where ..." Message isc_dsql_execute2 failed, -303, incompatible column, malformed string

Am I doing something wrong or is FlameRobin not able to handle UTF8?

I am using Firebird 4.0 64bit, FlameRobin 0.9.3 Unicode x64 (all just downloaded). Extracting the DDL with "iSQL -o" shows in the first line

/* CREATE DATABASE 'E:\foo.fdb' PAGE_SIZE 16384 DEFAULT CHARACTER SET UTF8; */

What is the character set of the column? Also, which version of FlameRobin and which version of Firebird are you using? — Mark Rotteveel, Dec 03 '21 at 16:11
I added data to the post above. The table or doesn't show different charset-definitions as far as I see (I posted the DDE of the table above) — ralfiii, Dec 03 '21 at 20:28

score 2 · Accepted Answer · answered Dec 04 '21 at 07:41

2

I can reproduce the issue (with blob character set UTF8 and connection character set UTF8), which suggests this is a bug in FlameRobin. I recommend reporting it on https://github.com/mariuz/flamerobin/issues. I'm not sure what the problem is. Updating does seem to work fine when using connection character set WIN1252.

Consider using a different tool, maybe DBeaver, or IBExpert, etc.

answered Dec 04 '21 at 07:41

Mark Rotteveel

100,966
191
140
197

2

Done: https://github.com/mariuz/flamerobin/issues/237 – ralfiii Dec 07 '21 at 08:25

Does FlameRobin have problems with the insertion of umlauts?

1 Answers1