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 |
|
amurark
Yak Posting Veteran
55 Posts |
 Posted - 2012-04-23 : 04:53:11
|
| Hi All,Pls tell me how to convert below data in readable format.it is tored in one table in one coulm but we cannot read it. 0x5F5243464D2A3D80902D05616C6572742A34382D2163757272656E742E70656E64696E672E67726F75707320696E20244C2E66696C652D05656D61696CA4A908A917FD0966696C652E6E616D65DD07244C2E66696C65A02D09696E636964656E7473A0A5A958DD1024472E7765627365727665722E75726CA0A0A02D0A61737369676E6D656E742D347B6E616D6520696E20244C2E66696C652C20756E697175652E6B657920696E20244C2E66696C652C20244C2E7765622E75726C7D2F2F2D05616C6572742A34372D287B6E616D6520696E20244C2E66696C652C20756E697175652E6B657920696E20244C2E66696C657D2F91902D05616C6572742A34382D2163757272656E742E70656E64696E672E67726F75707320696E20244C2E66696C652D05656D61696CA4A908A917FD0966696C652E6E616D65DD07244C2E66696C65A02D09696E636964656E7473A0A5A958DD1024472E7765627365727665722E75726CA0A0A02F2D347B6E616D6520696E20244C2E66696C652C20756E697175652E6B657920696E20244C2E66696C652C20244C2E7765622E75726C7D2F2F2F2F2F2F91902D05616C6572742A34392D2163757272656E742E70656E64696E672E67726F75707320696E20244C2E66696C652D05656D61696CA4A908A917FD0966696C652E6E616D65DD07244C2E66696C65A02D09696E636964656E7473A0A958DD1024472E7765627365727665722E75726CA0A02D0A61737369676E6D656E742D287B6E616D6520696E20244C2E66696C652C20756E697175652E6B657920696E20244C2E66696C657D2F2F2F2F2F2F91902D05616C6572742A34392D2163757272656E742E70656E64696E672E67726F75707320696E20244C2E66696C652D05656D61696CA4A908A917FD0966696C652E6E616D65DD07244C2E66696C65A02D09696E636964656E7473A0A958DD1024472E7765627365727665722E75726CA0A02F2D287B6E616D6520696E20244C2E66696C652C20756E697175652E6B657920696E20244C2E66696C657D2F2F2F2F2F2F91902D05616C6572742A34382D0C3120696E20244C2E617267732D05656D61696CA4A4A908A917FD0966696C652E6E616D65DD07244C2E66696C65A02D09696E636964656E7473A0A5A958DD1024472E7765627365727665722E75726CA0A0A0A5A958A91711DD07244C2E61726773A0A0A0A02D0A61737369676E6D656E742D287B6E616D6520696E20244C2E66696C652C20756E697175652E6B657920696E20244C2E66696C657D2F2F2F2F2F2F91902D05616C6572742A34382D0C3120696E20244C2E617267732D05656D61696CA4A4A908A917FD0966696C652E6E616D65DD07244C2E66696C65A02D09696E636964656E7473A0A5A958DD1024472E7765627365727665722E75726CA0A0A0A5A958A91711DD07244C2E61726773A0A0A0A02F2D287B6E616D6520696E20244C2E66696C652C20756E697175652E6B657920696E20244C2E66696C657D2F2F2F2F2F2F91902D05616C6572742A34392D0C3120696E20244C2E617267732D05656D61696CA4A4A908A917FD0966696C652E6E616D65DD07244C2E66696C65A02D09696E636964656E7473A0A958DD1024472E7765627365727665722E75726CA0A0A5A958A91711DD07244C2E61726773A0A0A0A02D0A61737369676E6D656E742D287B6E616D6520696E20244C2E66696C652C20756E697175652E6B657920696E20244C2E66696C657D2F2F2F2F2F2F91902D05616C6572742A34392D0C3120696E20244C2E6172'67732D05656D61696CA4A4A908A917FD0966696C652E6E616D65DD07244C2E66696C65A02D09696E636964656E7473A0A958DD1024472E7765627365727665722E75726CA0A0A5A958A91711DD07244C2E61726773A0A0A0A02F2D287B6E616D6520696E20244C2E66696C652C20756E697175652E6B657920696E20244C2E66696C657D2F2F2F2F2F2F91902D05616C6572742A34392D0C3120696E20244C2E617267732D05656D61696CA4A908A917FD0966696C652E6E616D65DD07244C2E66696C65A02C636D3372A0A5A958A91711DD07244C2E61726773A0A0A0A02F2D287B6E616D6520696E20244C2E66696C652C20756E697175652E6B657920696E20244C2E66696C657D2F2F2F2F2F2F91902D05616C6572742A34392D0C3120696E20244C2E617267732D05656D61696CA4A908A917FD0966696C652E6E616D65DD07244C2E66696C65A02C6F636D71A0A5A958A91711DD07244C2E61726773A0A0A0A02F2D287B6E616D6520696E20244C2E66696C652C20756E697175652E6B657920696E20244C2E66696C657D2F2F2F2F2F2F9181'Thanks in advance.Ankita |
|
|
vinu.vijayan
Posting Yak Master
227 Posts |
Posted - 2012-04-23 : 07:42:56
|
| What do you mean by the following??1."Readable Format"2."it is stored in one table in one coulm but we cannot read it"Does "Readable Format" mean converting it to a "String"?Does "it is stored in one table in one coulm but we cannot read it" mean that the user doesn't have rights to view the data in the table?If "Readable Format" means converting it to a "String" then you should have a look at the following links:[url]http://balajiramesh.wordpress.com/2008/03/10/convert-column-data-from-binary-to-string-with-sql-server-2005/[/url][url]http://sqlblog.com/blogs/peter_larsson/archive/2010/01/27/convert-binary-value-to-string-value.aspx[/url]If these don't help then please clarify on what you mean by "readable format".N 28° 33' 11.93148"E 77° 14' 33.66384" |
 |
|
|
|
|
|
convert binary data to text readable format