Milan Babuskov wrote:

> FlameRobin transliterates the entire statement to the connection
> character set (we do parse it to find identifiers for post-processing,
> but we never alter the user-entered string).
>
> I never tried, but if system table columns are UTF8, I assume FB should
> transliterate from connection charset to UTF8 when writing them.

Interesting. The problem I had was this, in FlameRobin 0.8.6 with FB
2.1, both running on the same Windows 2000 setup with Windows 1252
codepage (don't remember the connection charset, but I think it was
ISO8859_1 or WINDOWS_1252):

create table "Användare" (
"Lösenord" varchar(35) not null,
constraint "AnvändareLösenordLängd"
check (char_length("Lösenord") >= 8)
);

This statement executes fine, but when I try to commit I get this error:

------------------------------------
SQL Message : -104
Invalid token

Engine Code : 335544343
Engine Message :
invalid request BLR at offset 16
column Lösenord is not defined in table Användare
------------------------------------

Note that "Lösenord" appears correct in the message while "Användare"
appears mangled.

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64