Subject Re: [firebird-support] Firebird enters infinite? loop executing this query.
Author Andrew Guts
At 11:59 PM 18/12/2006, you 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 */

Thank you.

But it does not work. Even after restarting the Firebird. The "update"
operator right after the "commit" hangs as if without "commit". Any ideas ?