Subject | Re: [firebird-support] Firebird enters infinite? loop executing this query. |
---|---|
Author | Andrew Guts |
Post date | 2006-12-18T20:48:29Z |
At 11:59 PM 18/12/2006, you wrote:
But it does not work. Even after restarting the Firebird. The "update"
operator right after the "commit" hangs as if without "commit". Any ideas ?
Andrew
>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_wikiCOMMIT; /* !!!!!!!!!!!!!!!!!!!!!!!!!!!! */
>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;
>update cms_wiki setThank you.
>u_name = name, u_title = title, u_text = text, u_description =
>description; /* Here it hangs */
>
But it does not work. Even after restarting the Firebird. The "update"
operator right after the "commit" hangs as if without "commit". Any ideas ?
Andrew