firebird-support : Message: Re: trying to upgrade from 2.0 to 2.1

--- In firebird-support@yahoogroups.com, Adriano dos Santos Fernandes
<adrianosf@...> wrote:
> You could create new BLOB column using NONE charset, set it values and
> drop the problematic column.

In the end I had to update the text in the synopsis field to ansi
using Utf8ToAnsi() and then update it again by casting to none and
back to utf8 again.

THanks again

Tue Aug 12, 2008 5:38 am

Show Message Option

"markd_mms" <spam@...>

markd_mms

Offline

Send Email

Message #96231 of 118152 |

Expand Messages	Author	Sort by Date
I'm trying to upgrade from 2 to 2.1 so I can use the mon$ tables but I'm not having much luck. I was running v2.0.1.12855 under XP and I created a backup of...	markd_mms	Aug 7, 2008 2:19 am
... V2.0 was allowing malformed blobs, and it seems you have one in SYNOPSIS. You can't restore the database in V2.1 and can't use the metadata script in ODS...	Adriano dos Santos Fe... asfernandes2004	Aug 7, 2008 10:42 am
... I tried updating the synopsis by casting like in the metadata script and also by creating a new field with a different character set but I keep on getting...	markd_mms	Aug 10, 2008 11:23 pm
... You could create new BLOB column using NONE charset, set it values and drop the problematic column. Adriano...	Adriano dos Santos Fe... asfernandes2004	Aug 11, 2008 10:40 am
... In the end I had to update the text in the synopsis field to ansi using Utf8ToAnsi() and then update it again by casting to none and back to utf8 again. ...	markd_mms	Aug 12, 2008 5:38 am

< Prev Topic | Next Topic >

Advanced