| title | National character set support |
|---|---|
| description | Learn how to support national character set conversions in the Microsoft JDBC Driver for SQL Server. |
| author | David-Engel |
| ms.author | davidengel |
| ms.date | 08/12/2019 |
| ms.service | sql |
| ms.subservice | connectivity |
| ms.topic | concept-article |
[!INCLUDEDriver_JDBC_Download]
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.