running into the issue Varbinary data type in Prowatch db.

Post Reply
Deepak
Posts: 1
Joined: Thu Dec 15, 2016 6:16 am

running into the issue Varbinary data type in Prowatch db.

Post by Deepak »

- Many unique indentifier IDs are defined in Prowatch as varBinary(18) data type. And values in these columns should be converted into readable number such as int, bigInt or string.

- Converting them from ‘Varbinary’ into ‘Int’ data type, the result shows duplicated values. It is not working.

- Converting into ‘BigInt’, values show 18 digits which is too big.


Need help on how do we do this conversion to Int data type or String without any issues
Post Reply