[OAK-8915] RDBDocumentStore: use setNString() for columns known to be of type N*CHAR

• Type: Technical task
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.26.0, 1.8.21, 1.6.21, 1.22.2
• Component/s: rdbmk
• Assignee: Julian Reschke
• Reporter: Julian Reschke
• Created: 20/Feb/20 11:09
• Updated: 13/Sep/23 07:39
• Resolved: 20/Feb/20 13:12

Description

Microsoft's JDBC driver supports a connection property "sendStringParametersAsUnicode" (<https://docs.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver15>). When set to false, RDBDocumentStore would fail as the DATA column indeed requires Unicode.

The fix is to detect the type of the DATA column (similar on how we special-case ID), and use setNString() for these cases.

Issue Links

• relates to: OAK-8908 RDBBlobStore on SQL Server: bad performance when default collation is of type SQL*