mariuz / flamerobin

FlameRobin is a database administration tool for Firebird RDBMS. Our goal is to build a tool that is: lightweight (small footprint, fast execution) cross-platform (Linux, Windows, Mac OS X, FreeBSD) dependent only on other Open Source software
http://flamerobin.org
MIT License
216 stars 66 forks source link

FlameRobin has problems with the insertion of umlauts #237

Closed ralfiii closed 2 years ago

ralfiii commented 2 years ago

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; */

I originally reported this on https://stackoverflow.com/questions/70217294/does-flamerobin-have-problems-with-the-insertion-of-umlauts/70223841#70223841 Mark Rotteveel could reproduce it and asked me to report the issue here. Done.

arvanus commented 2 years ago

Please update to the latest snapshot (0.9.3.10) and try again Thanks

ralfiii commented 2 years ago

Works now. Thanks.