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!
posted 15 years ago
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).]