Re: [Firebird-net-provider] Convert BLOB to string

[<car...@te...>]

Hello:

> BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER SET NONE

It's correct, which version of the .NET Data Provider are you using ??

I have tested this with 1.5, and runs fine:

FbConnection connection = new FbConnection(connectionString);
connection.Open();

string sql = "select clob_field from test where int_field = 1";

FbCommand command = new FbCommand(sql, connection);

string value = (string)command.ExecuteScalar();

connection.Close();




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain