Subject Re: [firebird-support] Problems after converting VARCHAR(10000) to BLOB (3nd try)
Author Alexandre Benson Smith
jasperelzinga wrote:
> Hello,
>
> A few months ago we decided to convert our memofield from type
> VARCHAR(10000) to BLOB SUB_TYPE TEXT. All went well until some of our
> customers were having problems with conversions that involve the
> deleting of other tables.
>
I thnk what you did should be safe, let's wait for others opnions....

What I could recomend you to do is a back-up/restore cycle, this way the
restored database will be if it has the memo as blob from the beginning
(that is the case where the serve dont crash right ?)

Take care to restore it to another location, teste it before you restore
on your production database.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br