Subject Re: [firebird-support] Firebird enters infinite? loop executing this query.
Author Helen Borrie
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 */
>

./hb