From 5c909a7e3c11dbb8d01ad6f996d3be4d37c71227 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Ji=C5=99=C3=AD=20Filipovi=C4=8D?= Date: Wed, 21 May 2008 13:08:50 +0000 Subject: [PATCH] *** empty log message *** --- org.glite.jp.index/src/db_ops.c | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/org.glite.jp.index/src/db_ops.c b/org.glite.jp.index/src/db_ops.c index ad465a9..99e520f 100644 --- a/org.glite.jp.index/src/db_ops.c +++ b/org.glite.jp.index/src/db_ops.c @@ -34,14 +34,14 @@ #define SQLCMD_DROP_DATA_TABLE "DROP TABLE " GLITE_JP_INDEXDB_TABLE_ATTR_PREFIX "%s" #define SQLCMD_CREATE_DATA_TABLE "CREATE TABLE " GLITE_JP_INDEXDB_TABLE_ATTR_PREFIX "%s (\n\ - `jobid` CHAR(32) BINARY NOT NULL,\n\ - `value` %s BINARY NOT NULL,\n\ + `jobid` CHAR(32) NOT NULL,\n\ + `value` %s NOT NULL,\n\ `full_value` %s NOT NULL,\n\ `origin` INT NOT NULL,\n\ \n\ INDEX (jobid),\n\ INDEX (value)\n\ -) ENGINE=innodb;" +) CHARACTER SET utf8 COLLATE utf8_bin ENGINE=innodb;" #define SQLCMD_INSERT_ATTRVAL "INSERT INTO " GLITE_JP_INDEXDB_TABLE_ATTR_PREFIX "%|Ss (jobid, value, full_value, origin) VALUES (\n\ '%|Ss',\n\ '%|Ss',\n\ -- 1.8.2.3