Re: [Firebird-odbc-devel] Problem with Text Blob fields

[Werner F. B. <wer...@fr...>]

Hi Daniele,

Daniele Barzotti wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi,
>
> In my database I have a text BLOB filed defined as:
>
> NOTES Blob Sub_Type 1
>
> I'm using VB6 and ADO to access it and, when I write it it's correctly
> written (I read it with FlameRobin) while when I read it again it show
> me some '?' for example: ?????????????
>
> The sintax to write is:
> rsTable.Fields("NOTES") = txtNotes.Text
>
> ...and to read is:
> txtNotes.Text = rsTable.Fields("NOTES").Values
>
> I've tried also this:
> txtNotes = .Fields("NOTES").GetChunk( .Fields("NOTES").ActualSize )
>
> But .ActualSize is 0!
>
> Where is the mistake? May be a ODBC Driver issue?
>
> I'm using:
> Firebird    2.0.0.12748
> ODBC Driver 2.00.00.142
>   
As you see the Blob data correctly in FlameRobin (which reads it from 
the database) I would guess that you have a character set problem either 
in your ADO or your VB6 side of things.

Can you read the blob using e.g. OpenOffice or MS Word via ADO?  If yes 
then your problem is in your VB6 code (maybe the connection string?).

Werner