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 |
|
shaggy
Posting Yak Master
248 Posts |
 Posted - 2010-12-14 : 07:01:03
|
| hi all,is it possible to read varbinary data which is a text data stored as varbinary. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-12-14 : 07:10:26
|
Maybe this example helps?select convert(varbinary(500),'This is Fred!'),convert(varchar(500),convert(varbinary(500),'This is Fred!'))
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2010-12-14 : 07:11:42
|
| select convert(varchar(max),0x0001000000FFFFFFFF01000000000000000C02000000464C6F7241707050726F66696C652C2056657273696F6E3D322E3633352E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D6E756C6C05010000003969534F46542E4C4F52454E5A4F2E437573746F6D50726F66696C652E436F6D6D6F6E2E4349444C656E677468436F6E66696775726174696F6E010000000B6F637349444C656E677468042F69534F46542E4C4F52454E5A4F2E437573746F6D50726F66696C652E436F6D6D6F6E2E637349444C656E6774685B5D020000000200000009030000000703000000000100000052000000042D69534F46542E4C4F52454E5A4F2E437573746F6D50726F66696C652E436F6D6D6F6E2E637349444C656E67746802000000090400000009050000000906000000090700000009080000000909000000090A000000090B000000090C000000090D000000090E000000090F0000000910000000091100000009120000000913000000091400000009150000000916000000091700000009180000000919000000091A000000091B000000091C000000091D000000091E000000091F0000000920000000092100000009220000000923000000092400000009250000000926000000092700000009280000000929000000092A000000092B000000092C000000092D000000092E000000092F0000000930000000093100000009320000000933000000093400000009350000000936000000093700000009380000000939000000093A000000093B000000093C000000093D000000093E000000093F0000000940000000094100000009420000000943000000094400000009450000000946000000094700000009480000000949000000094A000000094B000000094C000000094D000000094E000000094F00000009500000000951000000095200000009530000000954000000095500000005040000002D69534F46542E4C4F52454E5A4F2E437573746F6D50726F66696C652E436F6D6D6F6E2E637349444C656E677468050000000C73436F7265536572766963650B7353756253657276696365077349444E616D65096949444C656E6774680C6949444D61784C656E67746801010101010200000006560000001843617265204D616E6167656D656E7420536572766963657306570000001A41636365737320506C616E6E696E67202D204D61696E2041505006580000000E41636365737320506C616E2049440659000000023230065A000000023230010500000004000000065B0000001843617265204D616E6167656D656E74205365727669636573065C0000001A41636365737320506C616E6E696E67202D204D61696E20415050065D0000000F4261746368204964204E756D626572065E000000023230065F00000002323001060000000400000006600000001843617265204D616E6167656D656E7420536572766963657306610000001C41636365737320506C616E6E696E67202D2053797320636F6E66696706620000000A50726F66696C652049440663000000023230066400000002323001070000000400000006650000001843617265204D616E6167656D656E7420536572766963657306660000000541646D697406670000001041646D697373696F6E204E756D62657206680000000231320669000000023132010800000004000000066A0000001843617265204D616E6167656D656E74205365727669636573066B0000000541646D6974066C00000012517569636B2041646D697373696F6E206E6F066D000000023530066E000000023530010900000004000000066F0000001843617265204D616E6167656D656E74205365727669636573067000000016416476616E636520426564204D616E6167656D656E7406710000000643435020494406720000000231300673000000023130010A0000000400000006740000001843617265204D616E6167656D656E7420536572766963657306750000001543617265204576656E74204D616E6167656D656E7406760000000C456E636F756E74657220494406770000000231320678000000023132010B0000000400000006790000001843617265204D616E6167656D656E74205365727669636573067A0000001543617265204576656E74204D616E6167656D656E74067B0000000A457069736F6465204944067C000000023132067D000000023132010C00000004000000067E0000001843617265204D616E6167656D656E74205365727669636573067F0000001543617265204576656E74204D616E6167656D656E7406800000001250617469656E74207061746877617920494406810000000232300682000000023230010D0000000400000006830000001843617265204D616E6167656D656E74205365727669636573068400000011436173656E6F746520547261636B696E67068500000008426174636820494406860000000232300687000000023230010E0000000400000006880000001843617265204D616E6167656D656E74205365727669636573068900000011436173656E6F746520547261636B696E67068A00000009566F6C756D65204944068B000000023530068C000000023530010F00000004000000068D0000001843617265204D616E6167656D656E74205365727669636573068E0000001D436F6E7472616374696E6720616E6420636F6D6D697373696F6E696E67068F0000000A547269676765722049440690000000023230069100000002323001100000000400000006920000001843617265204D616E6167656D656E7420536572766963657306930000000E456D657267656E6379206361726506940000001345787065637465642050617469656E742049440695000000023230069600000002323001110000000400000006970000001843617265204D616E6167656D656E7420536572766963657306980000000E456D657267656E637920636172650699000000114D616A6F7220496E636964656E74204944069A000000023235069B000000023235011200000004000000069C0000001843617265204D616E6167656D656E74205365727669636573069D0000000E456D657267656E63792063617265069E0000001B50617469656E742070726F70657274792072656365697074204944069F00000002323506A000000002323501130000000400000006A10000001843617265204D616E6167656D656E7420536572766963657306A2000000124C6F616E204974656D20547261636B696E6706A3000000074C6F616E20494406A400000002353006A500000002353001140000000400000006A60000001843617265204D616E6167656D656E7420536572766963657306A7000000124C6F616E204974656D20547261636B696E6706A80000000B5265736F7572636520494406A900000002333206AA00000002333201150000000400000006AB0000001843617265204D616E6167656D656E7420536572766963657306AC000000214D616E6167656D656E74206F6620457870656E736573202D204D61696E2041707006AD00000011457870656E73657320436C61696D20494406AE00000002323006AF00000002323001160000000400000006B00000001843617265204D616E6167656D656E7420536572766963657306B1000000234D616E6167656D656E74206F6620457870656E736573202D2053797320636F6E66696706B20000001D54726176656C20457870656E7365732043616C63756C61746F7220494406B300000002323006B400000002323001170000000400000006B50000001843617265204D616E6167656D656E7420536572766963657306B600000013526566657272616C204D616E6167656D656E7406B700000013436173656C6F61642050726F66696C6520494406B800000002323506B900000002323501180000000400000006BA0000001843617265204D616E6167656D656E7420536572766963657306BB00000013526566657272616C204D616E6167656D656E7406BC0000000F47656F67726170686963616C20494406BD00000002353006BE00000002353001190000000400000006BF0000001843617265204D616E6167656D656E7420536572766963657306C000000013526566657272616C204D616E6167656D656E7406C10000001350617469656E7420726566657272616C20494406C200000002323006C3000000023230011A0000000400000006C40000001843617265204D616E6167656D656E7420536572766963657306C500000013526566657272616C204D616E6167656D656E7406C60000001E526566657272616C207365727669636520646566696E6974696F6E20494406C700000002323506C8000000023235011B0000000400000006C90000001843617265204D616E6167656D656E7420536572766963657306CA00000013526566657272616C204D616E6167656D656E7406CB0000000A52545420506572696F6406CC00000002323506CD000000023235011C0000000400000006CE0000001843617265204D616E6167656D656E7420536572766963657306CF0000001D5363686564756C6520646566696E6974696F6E202D204461796361726506D000000012446179636172652073657373696F6E20494406D100000002323006D2000000023230011D0000000400000006D30000001843617265204D616E6167656D656E7420536572766963657306D40000001D5363686564756C6520646566696E6974696F6E202D204461796361726506D50000001B446179636172652073657373696F6E2074656D706C61746520494406D600000002323006D7000000023230011E0000000400000006D80000001843617265204D616E6167656D656E7420536572766963657306D90000001F5363686564756C6520646566696E6974696F6E202D20496E70617469656E7406DA0000001C44617920636172652073657373696F6E2074656D706C61746520494406DB00000002353006DC000000023530011F0000000400000006DD0000001843617265204D616E6167656D656E7420536572766963657306DE000000205363686564756C6520646566696E6974696F6E202D204F757470617469656E7406DF0000000D4F502073657373696F6E20494406E000000002323006E100000002323001200000000400000006E20000001843617265204D616E6167656D656E7420536572766963657306E3000000205363686564756C6520646566696E6974696F6E202D204F757470617469656E7406E4000000164F502053657373696F6E2074656D706C61746520494406E500000002323006E600000002323001210000000400000006E70000001843617265204D616E6167656D656E7420536572766963657306E8000000255363686564756C6520646566696E6974696F6E202D205761726420617474656E64616E636506E90000001A5761726420617474656E64616E63652073657373696F6E20494406EA00000002323006EB00000002323001220000000400000006EC0000001843617265204D616E6167656D656E7420536572766963657306ED000000255363686564756C6520646566696E6974696F6E202D205761726420617474656E64616E636506EE000000235761726420617474656E64616E63652073657373696F6E2074656D706C61746520494406EF00000002323006F000000002323001230000000400000006F10000001843617265204D616E6167656D656E7420536572766963657306F2000000245363686564756C6520646566696E6974696F6E202D20456D657267656E6379206361726506F30000000A53657373696F6E20494406F400000002323506F500000002323501240000000400000006F60000001843617265204D616E6167656D656E7420536572766963657306F7000000165375626A65637420416363657373205265717565737406F80000000653415220494406F900000002353006FA00000002353001250000000400000006FB0000001B436C696E6963616C206E617272617469766520736572766963657306FC00000022436C696E6963616C206E6F74696E6720616E6420636F72726573706F6E64656E636506FD00000016446F63756D656E742074656D706C61746520636F646506FE00000002323506FF00000002323501260000000400000006000100001E446961676E6F7374696320616E6420526573756C7420536572766963657306010100001D416476616E63656420526571756573747320616E6420526573756C74730602010000035365740603010000023235060401000002323501270000000400000006050100001E446961676E6F7374696320616E6420526573756C7420536572766963657306060100001D416476616E63656420526571756573747320616E6420526573756C747306070100000653657420494406080100000232350609010000023235012800000004000000060A0100001E446961676E6F7374696320616E6420526573756C74205365727669636573060B01000006506F6C696379060C01000019446570656E64616E7420416374697669747920506F6C696379060D010000023235060E010000023235012900000004000000060F0100001E446961676E6F7374696320616E6420526573756C74205365727669636573061001000006506F6C6963790611010000104475706C696361746520506F6C69637906120100000232350613010000023235012A0000000400000006140100001E446961676E6F7374696320616E6420526573756C74205365727669636573061501000006506F6C696379061601000011457363616C6174696F6E20506F6C69637906170100000232350618010000023235012B0000000400000006190100001E446961676E6F7374696320616E6420526573756C74205365727669636573061A01000006506F6C696379061B0100000E5072696E74657220506F6C696379061C010000023235061D010000023235012C00000004000000061E0100001E446961676E6F7374696320616E6420526573756C74205365727669636573061F01000006506F6C6963790620010000135472616E736D697373696F6E20506F6C69637906210100000232350622010000023235012D0000000400000006230100001E446961676E6F7374696320616E6420526573756C74205365727669636573062401000006506F6C696379062501000013566572696669636174696F6E20506F6C69637906260100000232350627010000023235012E0000000400000006280100001E446961676E6F7374696320616E6420526573756C742053657276696365730629010000085265717565737473062A01000015436F6C6C65637465642053706563696D656E204944062B010000023235062C010000023235012F00000004000000062D0100001E446961676E6F7374696320616E6420526573756C74205365727669636573062E010000085265717565737473062F01000009436F6E7461696E65720630010000023235063101000002323501300000000400000006320100001E446961676E6F7374696320616E6420526573756C742053657276696365730633010000085265717565737473063401000011496D6167652052657165737420466F726D0635010000023235063601000002323501310000000400000006370100001E446961676E6F7374696320616E6420526573756C74205365727669636573063801000008526571756573747306390100000E5265717565737420427562626C65063A010000023235063B010000023235013200000004000000063C0100001E446961676E6F7374696320616E6420526573756C74205365727669636573063D010000085265717565737473063E010000165265717565737420436174616C6F677565204974656D063F010000023235064001000002323501330000000400000006410100001E446961676E6F7374696320616E6420526573756C74205365727669636573064201000008526571756573747306430100000A526571756573742049440644010000023235064501000002323501340000000400000006460100001E446961676E6F7374696320616E6420526573756C74205365727669636573064701000008526571756573747306480100001052657175657374205069636B6C6973740649010000023235064A010000023235013500000004000000064B0100001E446961676E6F7374696320616E6420526573756C74205365727669636573064C010000085265717565737473064D0100000853706563696D656E064E010000023235064F01000002323501360000000400000006500100001E446961676E6F7374696320616E6420526573756C74205365727669636573065101000007526573756C7473065201000009526573756C742049440653010000023235065401000002323501370000000400000006550100001E446961676E6F7374696320616E6420526573756C74205365727669636573065601000007526573756C747306570100000E526573756C74204974656D20494406580100000232350659010000023235013800000004000000065A01000012446973636F76657279205365727669636573065B0100000745787472616374065C0100000B54656D706C617465204944065D010000023235065E010000023235013900000004000000065F01000012446973636F766572792053657276696365730660010000074578747261637406610100000A4578747261637420494406620100000235300663010000023530013A000000040000000664010000114964656E746974792053657276696365730665010000134964656E74697479204D616E6167656D656E7406660100001945787465726E616C20436172652070726F766964657220494406670100000232300668010000023230013B000000040000000669010000114964656E74697479205365727669636573066A010000134964656E74697479204D616E6167656D656E74066B0100000E504153204964656E746966696572066C010000023230066D010000023230013C00000004000000066E010000114964656E74697479205365727669636573066F010000134964656E74697479204D616E6167656D656E7406700100000C54656D706F7261727920494406710100000232300672010000023230013D000000040000000673010000114964656E7469747920536572766963657306740100000D50617469656E74204D657267650675010000104D65726765205265717565737420494406760100000235300677010000023530013E000000040000000678010000114964656E7469747920536572766963657306790100000D50617469656E74204D65726765067A01000012556E6D657267652052657175657374204944067B010000023530067C010000023530013F00000004000000067D010000114964656E74697479205365727669636573067E0100001450617469656E7420726567697374726174696F6E067F0100000B466163696C6974792049440680010000023230068101000002323001400000000400000006820100001E4D656469636174696F6E204D616E6167656D656E7420536572766963657306830100001C4F5020616E6420446973636861726765205072657363726962696E6706840100000C466F726D756C6172792049440685010000023530068601000002353001410000000400000006870100001E4D656469636174696F6E204D616E6167656D656E7420536572766963657306880100001C4F5020616E6420446973636861726765205072657363726962696E6706890100000E48696572617263687920436F6465068A010000023530068B010000023530014200000004000000068C0100001E4D656469636174696F6E204D616E6167656D656E74205365727669636573068D0100001C4F5020616E6420446973636861726765205072657363726962696E67068E0100000D496E6772656469656E74204944068F010000023530069001000002353001430000000400000006910100001E4D656469636174696F6E204D616E6167656D656E7420536572766963657306920100001C4F5020616E6420446973636861726765205072657363726962696E67069301000014496E746572616374696F6E2047726F75702049440694010000023530069501000002353001440000000400000006960100001E4D656469636174696F6E204D616E6167656D656E7420536572766963657306970100001C4F5020616E6420446973636861726765205072657363726962696E6706980100001D4D656469636174696F6E204661766F757269746573204C6973742049440699010000023530069A010000023530014500000004000000069B0100001E4D656469636174696F6E204D616E6167656D656E74205365727669636573069C0100001C4F5020616E6420446973636861726765205072657363726962696E67069D01000014507265736372696261626C65206974656D204944069E010000023530069F01000002353001460000000400000006A00100001E4D656469636174696F6E204D616E6167656D656E7420536572766963657306A10100001C4F5020616E6420446973636861726765205072657363726962696E6706A201000018507265736372697074696F6E206974656D206E756D62657206A301000002353006A401000002353001470000000400000006A50100001E4D656469636174696F6E204D616E6167656D656E7420536572766963657306A60100001C4F5020616E6420446973636861726765205072657363726962696E6706A701000013507265736372697074696F6E204E756D62657206A801000002353006A901000002353001480000000400000006AA0100001E4D656469636174696F6E204D616E6167656D656E7420536572766963657306AB0100001C4F5020616E6420446973636861726765205072657363726962696E6706AC0100001453656E73697469766974792047726F757020494406AD01000002353006AE01000002353001490000000400000006AF01000016536F6C7574696F6E20436F6E66696775726174696F6E06B001000017446174612053686172696E672041677265656D656E747306B10100001453686172696E672041677265656D656E7420494406B201000002323506B3010000023235014A0000000400000006B40100001853747275637475726564206361726520736572766963657306B5010000094361726520506C616E06B60100000B416374697669747920494406B701000002353006B8010000023530014B0000000400000006B90100001853747275637475726564206361726520736572766963657306BA010000094361726520506C616E06BB01000007476F616C20494406BC01000002353006BD010000023530014C0000000400000006BE0100001853747275637475726564206361726520736572766963657306BF010000094361726520506C616E06C0010000074E65656420494406C101000002353006C2010000023530014D0000000400000006C30100001853747275637475726564206361726520736572766963657306C4010000094361726520506C616E06C50100000B537472617465677920494406C601000002353006C7010000023530014E0000000400000006C80100001853747275637475726564206361726520736572766963657306C9010000094361726520506C616E06CA0100000B54656D706C61746520494406CB01000002353006CC010000023530014F0000000400000006CD0100000D5573657220536572766963657306CE01000012416476616E6365206469726563746976657306CF01000014416476616E63652064697265637469766520494406D001000002313006D101000002313001500000000400000006D20100000D5573657220536572766963657306D301000014436F6E73656E7420746F2074726561746D656E7406D40100000A436F6E73656E7420494406D501000002313106D601000002313101510000000400000006D70100000D5573657220536572766963657306D80100000C436F6E73656E74207479706506D90100000F436F6E73656E74207479706520494406DA010000013906DB010000013901520000000400000006DC0100000D5573657220536572766963657306DD0100001150617469656E742072656769737465727306DE0100000B526567697374657220494406DF01000002353006E001000002353001530000000400000006E10100000D5573657220536572766963657306E20100000E5465616D204D616E67656D656E7406E3010000065465616D494406E401000002323006E501000002323001540000000400000006E60100000D5573657220536572766963657306E70100000F55736572206D616E6167656D656E7406E80100000F526F6C652050726F66696C6520494406E901000002323006EA01000002323001550000000400000006EB0100001E446961676E6F7374696320616E6420526573756C7420536572766963657306EC01000008526571756573747306ED0100001647726F7570205265666572656E6365206E756D62657206EE01000002323506EF010000000B) this gives result as nothing |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-12-14 : 07:13:57
|
| YES,by converting varbinary to varchar we can read the data as string |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-12-14 : 07:14:42
|
| replace varchar(max) with varchar(64) |
|
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2010-12-14 : 07:17:13
|
| thanks ahmead i have tried urs it is not working....... |
|
|
|
|
|
|
read varbinary data