Hi,

I have a table with a BLOB field using UTF8 character set.

I´m connecting to this database using FlameRobin with ISO8859_1 character set.

I´m running a query in FlameRobin´s SQL Editor, and then saving the field data in a file using "Save BLOB to file..." context menu.

Case 1
select blob_field from table
The file is generated containing invalid ISO8859_1 characters

Case 2
select cast(blob_field as blob sub_type 1 character set iso8859_1) from table
The file is generated containing invalid ISO8859_1 characters

Case 3
select cast(blob_field as varchar(30000) character set iso8859_1) from table
The option "Save BLOB to file..." is not available because i converted to varchar, but if i copy the content of the field and save to a file, the characters are converted to valid ISO8859_1 characters.

Is there some problem of character set conversions from BLOB fields in this version? I´m having the same problem connecting with IBExpert and Delphi.

Regards,

Fabiano