Subject | RE: [IBO] Migrating to Firebird - problems with memo field and UTF8 |
---|---|
Author | Support List |
Post date | 2011-08-19T17:12:15Z |
Jacob,
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
> Hi - I'm trying to copy data from a BDE table to a IBOTable.What version of IBO are you using?
>
> 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.
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