title: What collation should I use to store £ (British Pound sign) in varchar?
body: <p>I'm using SQL Server Express 2008 R2. </p>
  
  <p>I'm importing from a csv file and some of the columns have a "£" sign as part of some free text. When this file is loaded into a database, the "£" sign is displayed as "ú". I think this is definitely to do with the database collation. The current database collation is Latin1_General_CI_AS.</p>
  
  <p>What collation will store "£" as "£" in SQL Server.</p>
  
  <p>Many thanks.</p>
  
  <p>Further info:
  I created a small file to demonstrate my issue here: <a href="https://www.dropbox.com/s/yvcx4t9nk9p0bf7/poundTest.txt" rel="nofollow">https://www.dropbox.com/s/yvcx4t9nk9p0bf7/poundTest.txt</a></p>
  
  <pre><code>use myDB;
  go
  
  create table test
  (id int,
  amt_range varchar(50));
  
  bulk insert test
  from 'F:\poundtest.txt'
  with (
  FIELDTERMINATOR = ',',
  ROWTERMINATOR = '\n',
  firstrow=1
  );
  select * from test;
  </code></pre>
  
  <p>This returns:</p>
  
  <pre><code>id  amt_range
  1   &lt;-ú200K
  2   -ú200K to -ú20k
  3   -ú20k to ú0k
  4   ú0k to ú20k
  5   ú20k to ú200k
  6   &gt;ú200k
  </code></pre>