How to convert Unicode Data to ASCII and back in SQL server

http://social.technet.microsoft.com/wiki/contents/articles/14036.how-to-convert-unicode-data-to-ascii-and-back-in-sql-server.aspx

http://blogs.msdn.com/b/nikosan/archive/2011/12/29/sql-server-and-utf-8-encoding-1-true-or-false.aspx