You are viewing a plain text version of this content. The canonical link for it is here.
Posted to oak-issues@jackrabbit.apache.org by "Solomon Rutzky (Jira)" <ji...@apache.org> on 2020/03/22 22:09:00 UTC
[jira] [Comment Edited] (OAK-8963) RDBBlobStore: on SQL Server,
specify binary collations upon table creation
[ https://issues.apache.org/jira/browse/OAK-8963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17063750#comment-17063750 ]
Solomon Rutzky edited comment on OAK-8963 at 3/22/20, 10:08 PM:
----------------------------------------------------------------
Based on the {{DATA}} column being {{VARBINARY(MAX)}} there is clearly no support for SQL Server 2000. Hence, the {{ID}} columns should use:
{code:sql}
COLLATE Latin1_General_BIN2
{code}
which is available in SQL Server 2005 and newer.
was (Author: solomon.rutzky):
Based on the {{DATA}} column being {{VARBINARY(MAX)}} there is clearly no support for SQL Server 2000. Hence, the {{ID}} columns should use:
{code:sql}
COLLATE Latin1_General_BIN2
{code}
> RDBBlobStore: on SQL Server, specify binary collations upon table creation
> --------------------------------------------------------------------------
>
> Key: OAK-8963
> URL: https://issues.apache.org/jira/browse/OAK-8963
> Project: Jackrabbit Oak
> Issue Type: Technical task
> Components: rdbmk
> Reporter: Julian Reschke
> Priority: Minor
> Attachments: OAK-8963.diff
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)