IBM Support

Configuring non-ASCII character support for WebSphere Application Server, Version 8.5 or later with Microsoft SQL Server

Preventive Service Planning


Abstract

If you are deploying IMS Server on WebSphere Application Server, Version 8.5 or later with Microsoft SQL Server, configure the sendStringParametersAsUnicode custom property to add support for non-ASCII characters.

Content

  1. On the WebSphere Application Server host, where IMS Server is installed, log on to the administrative console. For example: https://<hostname>:9043/ibm/console/
  2. In the navigation pane, select Resources > JDBC > Data sources.
  3. Select the name of your data source.
  4. In Additional Properties, select Custom properties.
  5. In the custom properties window, select sendStringParametersAsUnicode.
  6. In General Properties, set value to true.
  7. Click Apply.
  8. In the messages box, click Save.
  9. Restart the WebSphere Application Server.
[{"Product":{"code":"SS9JLE","label":"IBM Security Access Manager for Enterprise Single Sign-On"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.2.1;8.2.2","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

More support for:
IBM Security Access Manager for Enterprise Single Sign-On

Software version:
8.2.1, 8.2.2

Operating system(s):
Windows

Document number:
276691

Modified date:
16 June 2018

UID

swg21981585

Manage My Notification Subscriptions