Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
The JDBC driver provides support for the JDBC 4.0 API, which includes new national character set conversion API methods. This support includes new setter, getter, and updater methods for NCHAR, NVARCHAR, LONGNVARCHAR, and NCLOB JDBC types.
The following list shows new getter, setter, and updater methods to support the national character set conversion:
SQLServerPreparedStatement: setNString, setNCharacterStream, setNClob.
SQLServerCallableStatement: getNClob, getNString, getNCharacterStream, setNString, setNCharacterStream, setNClob.
SQLServerResultSet: getNClob, getNString, getNCharacterStream, updateNClob, updateNString, updateNCharacterStream.
Note
You must set the classpath to include the sqljdbc4.jar file to use these methods in your application.
To send String parameters to the server in Unicode format, the applications should either use the new JDBC 4.0 national character methods; or set the sendStringParametersAsUnicode connection property to "true" when using the non-national character methods. The recommended way is to use the new JDBC 4.0 national character methods where possible. For more information about the sendStringParametersAsUnicode connection property, see Setting the Connection Properties.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Introduction to SQL Server 2022 T-SQL enhancements - Training
SQL Server 2022 introduces a range of new features and enhancements, providing powerful tools and capabilities that optimize performance and offer better control on SQL objects manipulation and creation.