{"id":2644,"date":"2013-04-27T09:51:35","date_gmt":"2013-04-27T09:51:35","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2644"},"modified":"2013-04-27T09:51:35","modified_gmt":"2013-04-27T09:51:35","slug":"varchar-varbinary-%e6%97%a0%e6%8d%9f%e8%bd%ac%e6%8d%a2","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2013\/04\/27\/varchar-varbinary-%e6%97%a0%e6%8d%9f%e8%bd%ac%e6%8d%a2\/","title":{"rendered":"varchar <-> varbinary \u65e0\u635f\u8f6c\u6362"},"content":{"rendered":"<pre class=\"brush:sql;first-line:1;pad-line-numbers:true;highlight:null;collapse:false;\">\r\n--varchar -&gt; varbinary\r\ndeclare @hexstring varchar(64),@binstring varbinary(64)\r\nset @hexstring = &#39;0x01000200A09EFC30B04A69DE02000000000000000000000000000000000000&#39;;\r\nSET @binstring = CONVERT(varbinary(64), @hexstring, 1);\r\nSELECT @binstring\r\ngo\r\n\r\n--varbinary -&gt; varchar\r\ndeclare @hexstring varchar(64),@binstring varbinary(64)\r\nset @binstring = 0x01000200A09EFC30B04A69DE02000000000000000000000000000000000000\r\nSET @hexstring = master.dbo.fn_varbintohexstr(@binstring)\r\nSELECT @hexstring\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&#8211;varchar -&gt; varbinary declare @hexstring varchar(64 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-2644","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2644","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=2644"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2644\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}