Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Luke1st
Starting Member
2 Posts |
 Posted - 2015-04-04 : 14:05:31
|
| I've got value in column (varbinary(2048)). It is possible to get decimal value from this? To convert this, cast or something?May it encrypted value?Tell me it is impossible to obtain? By average database programmer? (Not hacker). I've got value like this (and this maybe it's decimal - 1.2 value or contains 1.2 it's possible?):0x7B0500000320205005070A00001AAC9B641285E44060EA00004D4CCC9FFFE01002001FF800000400000300FCCCCD4C7F39999B98FD9B99987E3333B33F4D4CEC9FCF017333C0DD55705CD4F3F33DFC04F33033FFC0404CC0CCCFF33D5FFFFFC0CFD7DFF013FFCCD4F7D4C07D5DF7C0C148CCCFCCFFCCCCC0C81ECDCC0C40199989A026A64650000004081E666626409D9B98588153F8CCCCCD03F4D4C9CA07F01030507090FF11F13C5F1733FF19ECDCC8C3FF9EBE67B80FF819E67ABA9EA6039E06A020279981F8D9A9BEB99E0AA78199E7FEE67E060207FB99A80EA781E679FEAEABF80F99EEBF9EF99809EBAE6AF8099FF9FEA679BFAFF80E7AE7B9AAF80E07BBFFEF83F8DE1786F8889FF8D98DE37E678D99E6E060A0F84F8586F87FE2BE2E7E7F8CE7FAE2E02607AFE6666B9BFFF809EE79EFF8099999FBA9BF999FE02AAA7EA0267980A9F9FFFAFBF8099F9FEAF809FF99FFEA7BFE039E67EE6FA980E67E7FEBBE603AFFFFEBBFFF9980FE0B830000002042F0DC3FC44CF19CC645DCF53FF50103F07C242C37C3F13F133F15CCFFC5CF5CCF70103F3F3353DFCCFF30155301C04DD4D4F33FCD77F3301CCF3F017351BDC0C07FF35FC040D4D4F3FFD701C040CD4FC04C05F535DFC0CF3CFDDFCF01FF3FF7337301335D75055C040557F030535FFFFF509C2F19C3FC746C54CC5F1B33C6F33C74CCDC0707C37C74445457F17C746CF533FCF1D553F7F01F0505F5CCFC040CC0CD5C140407FDF030535FCCF70155C15D7D4FCD4D5FF0133FFF3C07CCDF555F01F33CFFF7C073301357DCFCCFF01F335FFE01002001FF80000040573301501F5333FFFF7FC04F33F3D405D7FFD4F01C1C24F1DC771DC4C77C5C74F3FC6F1DC8000101027A818266E6062070B11F111DF3171731B3C754775355FECDCC8C3FAAEEB80AE7E060F9EBB980E6679EB81F9FEAABEFF809F99FEA6026BA8099E667FFBE02A6A7E7E660266FE603FFEAABABFB9F839E0678080EAA606EFFAF9EAF99FE02679EBFEFEA603E0EAB99F9EE0260E0FE1217F87FFE238CE2F9E62FE632E023A3617E1FE37898A99E2F8CF9F9F98DAAF99FB81829829F9809F980AAAF99A9EA67FFA99E06BFFAB9E602BAE6A6E78080BEBF9F999E6B9BFF809999E7FBEF80AAEA666A67BE780AFE67A9FEFE0267E679BBFF80E7F99A9EEB9FE020A7E6A03F8DF000000204770FC77C4C57C6CC67D7FFF301010319FC2F190FC445D4D717CCF1740000803FEFFE06E066B8DF83AFA80E0381F9FFE0380A9E020603B9F99BE03E0660EEAEE7A99E02780A981FAEA7AAEAF809BAAE799E7B980FAE027EA7AE7E0203E7E7EE6EB9F80999F99EEE667E66027FE67BB9809E666666A6E6B9B828485E363788E2A2A637F3333132046FFFE9A9939409199999A0770307F090FC4FF15C5FC646F331DCCD75D4D7DC07F03DCF77FCFDF53013757F37CDD753FDDF33013D7F733F5CFFC04C0D75333F55301F013FFCC0C057755037C0D40405D5CFC07013D4C0CF37CCD73DF01FFF3F7375F013FF5753F5F3C07033CF3D407C0C146FF09C2C643D412010020010480000040467133F317FFFCC0701C141C242F0D153C47C4CCFC57FFCF53CFF0130153033337F013CCF3CFFFF33F013FCCFCCFFFFD733CCF33F3FCCCF3FD4FFFFC0D5773F5CF535353FFFFFFCCF3CDCF5333F735333FF3F3F33FCF3FFFFCFDF5F01C0F05F07C6C2C371711FFC4C5F1753F19CF0107C2437C3C473313C5FF317F520000803FE6BFEF8D8199F829FEF80980E799F9E7B999EA799B9FA9EE7FFFF9BFAEA799EE7EA7B9FFEB999EAAFBFF99FEEABEE7FFEB9EEA6B99FFF9E6667F9FB9BE67EBE6026BBAA9EBF8181AEF80D3533B27FF1DC34C3F1D1D15F1D1D31B35331D7CF333030507C743FC6C4F1533319193FF8Thank you very much for reply. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2015-04-05 : 12:38:53
|
The content is way to large for only containing a "1.2" value.
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
 |
|
|
Luke1st
Starting Member
2 Posts |
Posted - 2015-04-06 : 09:21:13
|
| Maybe it's contains more informations. But it possible to obtain orginal value? |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-04-06 : 09:49:31
|
| Depends what you mean by original. It could be an image, a document, a memory dump, etc. etc. For example, http://www.forensicswiki.org/wiki/RAR shows that the start of your value, 0x7B, is used in RAR files. But it could be anything. |
|
|
|
|
|
|
|
|
Varbinary value in table column