Skip to main content
E
egfhockey
Participant
April 28, 2006
Question

Accessing NVARCHAR datatype from MSSQL 2000

  • April 28, 2006
  • 1 reply
  • 286 views
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
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
April 28, 2006
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?


E
egfhockeyAuthor
Participant
May 1, 2006
Yeah, I have done alot of reading. Sounds, simple. But still can't figure it out. Anyone?
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices