Subject RE: [IBO] Migrating to Firebird - problems with memo field and UTF8
Author Support List
Jacob,


> Hi - I'm trying to copy data from a BDE table to a IBOTable.
>
> I've created a Firebird database with the UTF8 charset.
>
> I use Delphi 2007.
>
> My problem is with memo fields, ie BLOB SUB_TYPE TEXT.
>
> This code:
>
> IBOTable.Fields[Col].Assign(BDETable.Fields[Col]);
>
> I get "Stream Write Error" if the field contains any special character
> like ÆØÅ.
>
> Shouldn't the Assign method know about this situation?
>
> If I do like this:
>
> IBOTable.Fields[Col].AsString := BDETable.Fields[Col]).AsString
>
> I don't get any errors but the data is garbled.
>
> String fields are converted just fine.

What version of IBO are you using?

Ideally you should not use a UTF8 database unless you are using Delphi 2009
or higher, but in the above case I think the Assign() method shouldn't have
an error. Perhaps you can provide me a sample app to look at if this problem
is still in the latest version of IBO.

I have released IBO 4.9.14 Build 14 as of August 11, 2011.
I think I neglected to announce this release.

Thanks,
Jason LeRoy Wharton
www.ibobjects.com