I think it would be better to post that to an IBExpert support group.

In Firebird, there is no such thing as ANSI_CHARSET or DEFAULT-CHARSET.

German Umlauts will be stored correctly by using one of these Firebird
Character Sets:
- ISO8859_1
- WIN1252
- UTF8

However, your client (IBExpert in this case) must know how to handle
it, especially UTF8 (which is a form of Unicode).

Viele Grüße

Stefan

> I'm new to Firebird (2.0.1 / Windows XP SP2 / Windows 2003 Server).

> I created a new db with character set UTF8 and ANSI_CHARSET. If I try
> to insert a record with a field containing e.g. german umlauts like Ä
> or Ü the record will not be inserted. The same happens with
> DEFAULT-CHARSET and character set WIN1252. Without those characters
> the insert will be done.

> Error message: "Unsuccessful execution caused by system error that
> does not preclude successful execution of subsequent statements.
> number of seconds required." (DB frontend is IBExpert)

> As UTF8 and WIN1252 are recognizing international characters I wonder
> why I can't store those characters to the database?

> Thanks for any help.
> Christian Lauer