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

[Daniele B. <dan...@eu...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Daniele Barzotti ha scritto:
> 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: ?????????????
> 

I remember that VB works in Unicode!
I've solve the problem simply do the following:

.Fields("NOTES").Value = StrConv(TxtNotes, vbFromUnicode)

for writing and

TxtNotes = StrConv(.Fields("NOTES").Value, vbUnicode)

for reading!

Thanks a lot!

Regards,
Daniele.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFFvdqd/l+kMioSZwgRAuX/AKCQMvd+LoBqpUBG5jFeTqA5pW9txQCg3J+M
v7vurNQSPlhfCNaaUw0a8RI=
=7TXg
-----END PGP SIGNATURE-----