| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | apilocation | apiname | apitype |
|---|---|---|---|---|---|---|---|---|---|---|
setSendStringParametersAsUnicode Method (SQLServerDataSource) |
setSendStringParametersAsUnicode Method (SQLServerDataSource) |
David-Engel |
davidengel |
01/19/2017 |
sql |
connectivity |
reference |
sqljdbc.jar |
SQLServerDataSource.setSendStringParametersAsUnicode |
Assembly |
[!INCLUDEDriver_JDBC_Download]
Sets a boolean value that indicates if sending string parameters to the server in UNICODE format is enabled.
public void setSendStringParametersAsUnicode(boolean sendStringParametersAsUnicode)
sendStringParametersAsUnicode
true if string parameters are sent to the server in UNICODE format. Otherwise, false.
If the sendStringParametersAsUnicode property is set to true, which is the default value, string parameters are sent to the server in UNICODE format. If sendStringParametersAsUnicode is set to false string parameters are sent to the server in an ASCII/MBCS format, not in UNICODE. If sendStringParametersAsUnicode is not set, getSendStringParametersAsUnicode returns the default value of true.
Note: Changing this value can affect sorting of results from the database. The sorting differences are due to different sorting rules for Unicode versus non-Unicode characters.
For more information about the sendStringParametersAsUnicode connection property, see Setting the Connection Properties.