I'm updating data in column [S.STATUS] and get an error:
SQL Error  : arithmetic exception, numeric overflow, or string truncation; Cannot transliterate character between character sets [SQLState:22018, ISC error code:335544565]'
I'm using DBeaver 6.0.2 and DB is Firebird 2.5.
Column Name, Data Type, Charset, Length STATUS, SMALLINT, [NULL], 5
I've tried to update multiple rows, single row, cast (S.STATUS as SMALINT) etc.
UPDATE Table S SET S.STATUS = 3 WHERE S.ID = 580864
Now [S.STATUS] = 9, I want to change it to [S.STATUS] = 3.
Probably the problem is that S.STATUS is primary key in other table [Table2]: 'Caused by: java.sql.SQLException: violation of PRIMARY or UNIQUE KEY constraint "Table" on table "Table2"; Problematic key value is ("ID" = 3) [SQLState:23000, ISC error code:335544665]