Efrain Morales wrote:
The insertion to the database is done by another ESB service, which receives the query as part of an XML.
Meaning that I do not have direct access to the database, but I can send the query via JMS and it gets executed.
I've tried your recommendation but apparently it will only work for arrays of length of 128 or less. Anything bigger results in the following error:
Msg 103, Level 15, State 5, Line 0
The number that starts with '37806870454946511037868584831052324832111981061060603247841211121013247731101021111047801141111001179910111432407079803248465048' is too long. Maximum length is 128.
*Edit*
It will only work for arrays of 64 bytes, since each byte is 2 chars long
Any ideas?