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.

Thanks
Jacob


[Non-text portions of this message have been removed]