markd_mms escreveu:

> --- In firebird-support@yahoogroups.com, Adriano dos Santos Fernandes
> <adrianosf@...> wrote:
>> So you will need to open (a copy) of this (ODS 11.0) database in V2.1
>> and fix the UTF8 blobs problems and backup later. You could see how
>> metadata script does it (using casts).
>>
>>
>> Adriano
>
> 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 'Cannot transliterate character between character
> sets.', which I'm guessing is what the problem is. Is there any way
> I'm going to be able to fix this without having to write a program to
> select and then update the synopsis with nice-ified text?
>

You could create new BLOB column using NONE charset, set it values and
drop the problematic column.


Adriano