[
https://issues.apache.org/jira/browse/OAK-1913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14264685#comment-14264685
]
Thomas Mueller commented on OAK-1913:
-------------------------------------
A first test indicates that for the primary key, using binary (and our own
UTF-8 conversation) might work. Tested using [SQL Fiddle with MySQL
5.5.32|http://sqlfiddle.com/#!2/10c21]:
{noformat}
create table test(id varbinary(767) primary key, data int);
insert into test values(x'00010203', 1);
insert into test values(x'010203', 2);
insert into test values(x'0203', 3);
select *, length(id) from test where id >= x'0102';
{noformat}
Concatenating binary data in MySQL [also seems to
work|http://stackoverflow.com/questions/5325379/mysql-how-to-concat-append-binary-data-type]
(I didn't test yet).
> RDB: MariaDB (MySQL) support
> ----------------------------
>
> Key: OAK-1913
> URL: https://issues.apache.org/jira/browse/OAK-1913
> Project: Jackrabbit Oak
> Issue Type: Sub-task
> Components: rdbmk
> Reporter: Julian Reschke
> Priority: Minor
> Fix For: 1.2
>
> Attachments: OAK-1913-v2.patch, OAK-1913.patch
>
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
