title: How to get proper column types in Sybase
body: <p>I have to know the data type of some columns in my table in Sybase ASE. Here is my query</p>
  
  <pre><code>select name from systypes
  where type in (39,
  47,
  39,
  39,
  106
  )
  </code></pre>
  
  <p>this returns</p>
  
  <pre><code>char       
  varchar    
  sysname    
  nchar      
  nvarchar       
  decimaln       
  longsysname    
  </code></pre>
  
  <p>I was hoping it would return </p>
  
  <pre><code>varchar
  char
  varchar
  varchar
  decimaln
  </code></pre>
  
  <p>why are the results not as expected ? How can i get the proper column types ? I intend to use this information later to create a dynamic query that creates another table.</p>