title: How to handle ascii control characters in sql server?
body: <p>How can we handle ascii characters using sql server 2005? Which data type can I use to store ascii characters, mainly control characters? </p>
  
  <p>For example: I have a file with strings delimited by some control characters like backspace.  I need to read this file into my sql server tables. I want to know what data type (char,nchar,varchar, ..) I can use to store them. </p>
  
  <p>Also, all the string split functions I have seen work well with normal delimiters like <code>,</code>. But my delimiter is backspace <code>\b</code>.</p>