NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Niels Larsen on December 21, 2020, 11:02:58 AM

Title: NT12 BLOB - Error
Post by: Niels Larsen on December 21, 2020, 11:02:58 AM

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

Title: Re: NT12 BLOB - Error
Post by: Bruce on December 21, 2020, 10:00:25 PM

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

Title: Re: NT12 BLOB - Error
Post by: Niels Larsen on December 22, 2020, 08:30:00 AM

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

Title: Re: NT12 BLOB - Error
Post by: Bruce on December 23, 2020, 09:26:22 PM

Perhaps set the clarion side to Binary as well?

Title: Re: NT12 BLOB - Error
Post by: Niels Larsen on December 27, 2020, 10:23:02 AM

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

Thanks!