How to convert a String to Hex and vice-versa?

As you know , in MySQL we have HEX & UNHEX, for example when I write like this :

select hex("Ali");

the convert result is : 416C69

and the unhex is like this : select unhex("416C69");

In MSSQL I can't convert this, could you please give me an example for both of them ???

Thanks a lot ...

Answers


I think this should work

SELECT     hex(CAST("Ali" AS VARBINARY)) AS Expr1

for vice versa

select CONVERT(varbinary(max), "416C69");

This will convert to varbinary, then you can convert varbinary to varchar

Converting a String to HEX in SQL

http://blogs.msdn.com/b/sqltips/archive/2008/07/02/converting-from-hex-string-to-varbinary-and-vice-versa.aspx


Need Your Help

R pie charts : How to allocate the colors according to a variable?

r graphics ggplot2 pie-chart

I'm making a set of pie charts in R (with a loop) out of subsets from a single data frame. I get nice pie charts but the colors are allocated always in the same order in each pie while I would like...

PInvoke and IStream

c# pinvoke unmanaged istream

I have an exported function from a dll written in c++ with the following signiture:

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.