What is the DBC setting needed for specifying the encoding of the target database column ?

Hi All,

I'm using JDBC in a Java program to get data from SQL Server 7.0. I'm
using Sun's jdbc-odbc driver.

In this context can anyone please let me know whether is it possible to
specify the encoding of the data stored in SQL server at the JDBC level
(i.e. through JDBC API or at the DSN definition) ?

The purpose for which I'm looking for this information is that I want
the jdbc driver to properly convert the data from Java's internal
Unicode representation to the target database column's encoding and
vice-versa while inserting and fetching the data respectively.

Any help will be greatly appreciated.

Thanks in advance,
Sourav