File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Date Type Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Date Type" Watch "Date Type" New topic
Author

Date Type

sandy yang
Greenhorn

Joined: Jan 26, 2001
Posts: 8
I using MS SQL Server's Northwind database as my simple database,
I try to display information form Employees table, the data type is "TEXT" for employee's name in SQL Server. My question is: What's the matching java type for it? when I use resultSet.getObject, the program runs, and the column is blank, no employee's name will display. when I use ResultSetMetaData.getColumnTypeName, I get the data is "nvarchar". I can't find the matching java data type for it.
Thanks!
David Freels
Ranch Hand

Joined: Feb 01, 2001
Posts: 102
Try using resultSet.getString. The Oracle JDBC driver has problems with the getObject method so maybe your driver does as well.

UPDATE:
I was just informed by a SQL Server admin that the nvarchar is a UNICODE field.
Hope this helps.
David
[This message has been edited by David Freels (edited March 09, 2001).]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Date Type
 
Similar Threads
JDBC-ODBC(VERY VERY URGENT PLEASE)
stuck up in the problem
Java noob -- sentinel-controlled while loop
Problems changing foreign key references in Grails?
Could not parse configuration: /hibernate.cfg.xml