title: c# unicode to char - is there an equivalent of this in t-sql
body: <p>I have a unicode value that when I assign to char gets the following:</p>
  
  <pre><code>protected void Page_Load(object sender, EventArgs e)
  {
      char test = '\ue900'; //This makes test = 59648'.'
  }
  </code></pre>
  
  <p>Is there a way to get 59648'.' in t-sql. I'm not even sure why there is a '.' behind the number?</p>