running into the issue Varbinary data type in Prowatch db.
Posted: Thu Dec 15, 2016 6:30 am
- 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
- 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