--- In firebird-support@yahoogroups.com, Hannes Streicher
<hstreicher@...> wrote:

>
> Guten Tag Daniel,

> i have not been following the discussion , but what characterset do
> you use, ?
> possibly your varchar 32000 are exceedig the limit ,
> the Limit is not 32000 characters , but 3276? bytes , so depending

on

> characterset used you may only have 10920 or so chars
>
> Mit freundlichen Grüssen
> Hannes Streicher mailto:HStreicher@...

Hallo Hannes

You pointed me into the right direction, thank you very much.

I am using character set ISO8859_1. Since I replaced the two varchar
(32000) fields with blobs the query works fine.

ALTER TABLE RELATION DROP NOTE;
ALTER TABLE RELATION DROP NOTEPRIVATE;
alter table Relation add Note Blob sub_type 1;
alter table Relation add NotePrivate Blob sub_type 1;

Viele Grüsse aus Südafrika
Daniel

P.S.: Helen: You wrote a great book and are an extremely knowledgable
woman, I forgive you (I read over an hour through the release notes
and felt very bad) :-)