title: How to insert greek characters into sqlserver table
body: <p>I have a simple insert, but with greek characters</p>
  
  <pre><code>INSERT INTO tmp (fname) VALUES ('ΚΩΝΣΤΑΝΤΙΝΟΣ')
  </code></pre>
  
  <p>I have tried creating the table in two ways:</p>
  
  <pre><code>create table tmp (fname varchar(40))
  </code></pre>
  
  <p>and</p>
  
  <pre><code>create table tmp (fname nvarchar(40))
  </code></pre>
  
  <p>When I then select the data:</p>
  
  <pre><code>select * from tmp
  </code></pre>
  
  <p>I get:</p>
  
  <pre><code>?O?S???????S
  </code></pre>
  
  <p>I'm using:</p>
  
  <pre><code>Microsoft SQL Server 2005 - 9.00.4060.00 (Intel X86) 
      Mar 17 2011 13:20:38 
      Copyright (c) 1988-2005 Microsoft Corporation
      Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
  </code></pre>
  
  <p>and</p>
  
  <pre><code>Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64) 
      Oct 19 2012 13:38:57 
      Copyright (c) Microsoft Corporation
      Standard Edition (64-bit) on Windows NT 6.1 &lt;X64&gt; (Build 7601: Service Pack 1) (Hypervisor)
  </code></pre>
  
  <p>it does the same in both.</p>
  
  <p>I'm using:</p>
  
  <pre><code>Microsoft SQL Server Management Studio  11.0.2100.60
  </code></pre>
  
  <p>to create the table and insert the data etc.</p>
  
  <p>How do I get Greek characters to store correctly or if they are stored correctly to display correctly when I select them?</p>