Base64 question

[Thys]

Hi.

This is not a NetTalk question, but rather a general question which I experience in my NetTalk web service.

We have an MS SQL table where the owner decided to have a "Photo" column of type varbinary(max)  to store an image. The way that I've dealt with images before, is to rather have a varchar(max) column type and store the image as a Base64-encoded value.

For this varbinary(max) column, I use Stringtheory to decode the Base64 value received, but it still causes MS SQL to throw an error - I suppose because Clarion is trying to save a string instead of binary values. I have tried changing the type in the dictionary to both BLOB and PICTURE, both result in a Clarion runtime error.

Is there anyone that has dealt within this data type before?

Thys

[Thys]

This is the error returned:

[22005] Invalid character value for cast specification