How to find which character set the database is using

Question

I can access the database either from a .NET program (using ODBC) or using a database management tool (written in Java).

If I write the symbol "é" to the database from the .NET program, it is displayed as "Õ" (capital O with tilde) in the DB management tool.

If I write the symbol "é" in the database from the database management tool, it will appear as "Å" (capital A with a circle above) in the .NET program.

I am not trying to actually solve the problem (i.e. both programs show the same thing), although that would be nice. I'm just trying to guess which character sets each uses to interpret the data, so I can do the conversion myself if I dump the data using .NET and re-enter it using this tool.

So, which combination of the two character sets would produce the character mismatches described above?

Thank you for your help.

EDIT: using Sybase ASE 12.5

EDIT: basically the question is: do you know about character encoding, whose code point E9 represents the character "X" (capital O with tilde) or "Å" (capital A with a circle up)? (this suggests that one of them uses Latin 1, hence E9, which I think is pretty likely)

EDIT: Paul's solution does this. Answer about the coding: hp-roman8

Answer 1

Sybase automatically attempts to perform the conversion if the server and client use different characters. If you turn off automatic character set conversion using

set char_convert off

Do you still have the same Õ and Å?