title: Moving to Unicode - Questions about how it works
body: <p>I've been tasked with getting us ready for to go to Unicode for various character sets including Chinese, Russian, and Korean.<br>
  One of the things that I'm focusing on is SSIS. I've tested a simple lookup, and it works fine. But now I'm running into questions about these languages. <br></p>
  
  <ul>
  <li>Can you do an Upper on Kanji?</li>
  <li>How does sort work if you have Russian and Japanese in column?</li>
  <li>Hebrew and Arabic are both written Right to Left, however when I do a substring for the first character in Arabic I get the leftmost one, but Hebrew gives me the rightmost one.</li>
  <li>What about character sets? If I use a french keyboard and write a name, but another time use the same letters on a russian keyboard, will a Lookup find the connection?<br></li>
  </ul>
  
  <p>Any advice would be appreciated.</p>