I had a simple search and result website built using JSP. The database I access is MSSQL 2000. The program that uses it was upgraded, and a few of the fields datatypes were changed from varchar to nvarchar. Now, those fileds don't return any data in my JSP results page. How can I get the JDBC to read the NVARCHAR datatype?

I can run the test from my recordset test button and everything works fine. Also use SQL Query Analyzier and the data returns fine. So it has to be something with the JDBC.