title: How to find which character set is used by the database
body: <p>I can access the database either from a .NET program (using ODBC) or through a database management tool (written in Java).</p>
  
  <p>If I write a 'é' character to the database from the .NET program, it appears as 'Õ' (capital O with tilde) in the DB management tool.</p>
  
  <p>If I write a 'é' character to the database from the DB management tool, it appears as 'Å' (capital A with a circle on top) in the .NET program.</p>
  
  <p>I am not trying to actually solve the problem (i.e. having both programs show the same thing), although that would be nice. I am merely trying to guess which character sets each is using to interpret the data, so that I can do the conversion myself if I dump data using .NET and re-input it using the tool.</p>
  
  <p>So, which combination of 2 character sets would give the character mismatches described above?</p>
  
  <p>Thanks for your help.</p>
  
  <p><strong>EDIT:</strong> using Sybase ASE 12.5</p>
  
  <p><strong>EDIT:</strong> basically the question is: do you know of a character encoding whose E9 code point represents character 'Õ' (capital O with tilde) or 'Å' (capital A with a circle on top)? (this supposes one of them is using Latin 1, hence the E9, which I think is pretty likely)</p>
  
  <p><strong>EDIT:</strong> Paul's solution does it. The answer about the charset is: <a href="http://www.kostis.net/charsets/hproman8.htm" rel="nofollow noreferrer">hp-roman8</a></p>