NT12 BLOB - Error

[Niels Larsen]

Hi Bruce

I am very excited that it has become easy to use BLOB for text.
But when I use it with MSSQL I get the following error:

Invalid character value for cast specification (22005).

Any idea?

Regards Niels

[Bruce]

Hi Niels,

I'm not a SQL expert, but I'm guessing this has to do with the declaration of your blob in the database, and the dictionary. Perhaps let us know how the field is declared in the dictionary, and in the SQL table, and whether it is binary in either, or both, places?

the code in NetTalk is using the database driver, so there's no special "blob" handling on my side - I'm just using normal Clarion blob behaviors.

Cheers
Bruce

[Niels Larsen]

Hi Bruce

In Clarion it's defined as a non binary blob. And ends up in SQL as a binary image.
This is weird because when I work with jFiles2 and blobs I have no issues at all.
Well, I have to dig a little deeper into what it's going on and what I'm doing wrong.

/Niels

[Bruce]

Perhaps set the clarion side to Binary as well?

[Niels Larsen]

Yes. Defining it as binary works.
The only thing I didn't try....

Thanks!