Accessing NVARCHAR datatype from MSSQL 2000

[egfhockey]

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.

Thanks. Corey

[Newsgroup_User]

NVARCHAR (and the other n-prefixed character data types) uses Unicode text
instead of ANSI text. You might have to tell your JSP page somehow. I'm
not one to know, but I do know that's the only difference between the data
types.

"egfhockey" <webforumsuser@macromedia.com> wrote in message
news:e2tmf6$b60$1@forums.macromedia.com...
> How can I get the JDBC to read the NVARCHAR
> datatype?

[egfhockey]

Yeah, I have done alot of reading. Sounds, simple. But still can't figure it out. Anyone?