Welcome! Log In Create A New Profile

Advanced

Solved: SQLServer Native image field question

Posted by Jeff Graham 
Solved: SQLServer Native image field question
December 03, 2021 11:07PM
I have an SQL Server table imported from Visual Manufacturing that has a definition of (Image,null) in SQL and in WD 26 analysis it is defined as image (binary memo) sub type. The field actually has a string of hex characters. In WD 23 I could use it as a string. However in WD 26 the debugger shows it as having a value = image and only the first letter get used. See attached file.

Any suggestions would be greatly appreciated,

After much testing of different Sub-Types, I found that Image (Binary Memo) with UnicodeToANSI() gets the correct result but you cannot see the content of the field with the Debbuger as is only says 'Image'.

Jeff Graham
Cascade Consulting



Edited 1 time(s). Last edit at 12/04/2021 10:20PM by Jeff Graham.
Author:

Your Email:


Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: