I don't know what's wrong Andrew, but in general you should run DDL and
DML in separate transactions in Firebird. So try committing between
ALTER TABLE and UPDATE.

HTH,
Set

Andrew Guts wrote:

> Hello Firebird Support,
>
> I need to convert some of my database fields into UTF-8. So I wrote and
> run operator by operator the script below:
> --------------------------------------------------------
> alter table cms_wiki
> add u_name varchar(100) character set UTF8,
> add u_title varchar(100) character set UTF8,
> add u_description blob sub_type 1 character set UTF8,
> add u_text blob sub_type 1 character set UTF8;

COMMIT;

> update cms_wiki set
> u_name = name, u_title = title, u_text = text, u_description =
> description; /* Here it hangs */
>
> commit;