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

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

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

Werner F. Bruhin ha scritto:

Hi Werner!

Thanks for your reply!

> 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.

Mmmm..maybe!
I didn't ever care about the character sets! :-(

> 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?).
> 

The "Default character set" for my DB is set to NONE

And the connection string I use is:

DRIVER=Firebird/InterBase(r) driver; UID=myUserName;
PWD=myPassword;DBNAME=127.0.0.1:myDbPath;

I've tried to open it with OpenOffice (2.1) through ADO but I can't see
any tables!!!

Now I try to alter my Notes Domain from:

CREATE DOMAIN T_NOTE AS Blob sub_type 1 COLLATE NONE;

to

CREATE DOMAIN T_NOTE AS Blob sub_type 1 CHARACTER SET UNICODE_FSS
COLLATE NONE;

But I don't understand why the insertions works....

Thanks a lot!
Daniele.

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

iD8DBQFFvdef/l+kMioSZwgRAqg5AJ4ruxLVljtNSQ/Yd/gTlvi1JBO7bwCgol6r
GLZ40aYBagxrbzONZkJAP2o=
=1OTD
-----END PGP SIGNATURE-----