Subject [IBO] Migrating to Firebird - problems with memo field and UTF8
Author Jacob Havkrog
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:


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.


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