Author: dkuleshov Date: 2010-12-02 08:52:47 -0500 (Thu, 02 Dec 2010) New Revision: 3594 Modified: jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.mysql-utf8.sql jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.mysql-utf8.sql Log: EXOJCR-1087: changed collation to case-sensitive Modified: jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.mysql-utf8.sql =================================================================== --- jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.mysql-utf8.sql 2010-12-02 13:47:14 UTC (rev 3593) +++ jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.mysql-utf8.sql 2010-12-02 13:52:47 UTC (rev 3594) @@ -5,7 +5,7 @@ CREATE TABLE JCR_MITEM( ID VARCHAR(56) NOT NULL, PARENT_ID VARCHAR(56) NOT NULL, - NAME VARCHAR(512) CHARACTER SET utf8 NOT NULL, + NAME VARCHAR(512) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, VERSION INTEGER NOT NULL, I_CLASS INTEGER NOT NULL, I_INDEX INTEGER NOT NULL, Modified: jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.mysql-utf8.sql =================================================================== --- jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.mysql-utf8.sql 2010-12-02 13:47:14 UTC (rev 3593) +++ jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.mysql-utf8.sql 2010-12-02 13:52:47 UTC (rev 3594) @@ -5,7 +5,7 @@ CREATE TABLE JCR_SITEM( ID VARCHAR(56) NOT NULL, PARENT_ID VARCHAR(56) NOT NULL, - NAME VARCHAR(512) CHARACTER SET utf8 NOT NULL, + NAME VARCHAR(512) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, VERSION INTEGER NOT NULL, CONTAINER_NAME VARCHAR(24) NOT NULL, I_CLASS INTEGER NOT NULL,