[
https://issues.apache.org/jira/browse/OAK-8915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Reschke updated OAK-8915:
--------------------------------
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.
was:
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 setN*Char
> RDBDocumentStore: use setNString() for columns known to be of type N*CHAR
> -------------------------------------------------------------------------
>
> Key: OAK-8915
> URL: https://issues.apache.org/jira/browse/OAK-8915
> Project: Jackrabbit Oak
> Issue Type: Technical task
> Components: rdbmk
> Reporter: Julian Reschke
> Assignee: Julian Reschke
> Priority: Minor
> Fix For: 1.26.0
>
>
> 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.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
