From dd2fdd128dfb5998479f9edf89d0cfa3afe53fbd Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Tue, 13 Dec 2005 18:49:47 +0000
Subject: - Patch #40532 by wtanaka: use longblog for data in the cache.  Is
 reported to fix utf-8 problems and improves consistency with PostgreSQL.

---
 database/database.mysql | 2 +-
 database/updates.inc    | 7 +++++++
 2 files changed, 8 insertions(+), 1 deletion(-)

(limited to 'database')

diff --git a/database/database.mysql b/database/database.mysql
index 5cbc889f3..c96c51ee3 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -166,7 +166,7 @@ CREATE TABLE boxes (
 
 CREATE TABLE cache (
   cid varchar(255) NOT NULL default '',
-  data longtext,
+  data longblob,
   expire int(11) NOT NULL default '0',
   created int(11) NOT NULL default '0',
   headers text,
diff --git a/database/updates.inc b/database/updates.inc
index 6dbc04368..a44580c18 100644
--- a/database/updates.inc
+++ b/database/updates.inc
@@ -1273,3 +1273,10 @@ function system_update_162() {
   return $ret;
 }
 
+function system_update_163() {
+  $ret = array();
+  if ($GLOBALS['db_type'] == 'mysql') {
+    $ret[] = update_sql('ALTER TABLE {cache} CHANGE data data LONGBLOB');
+  }
+  return $ret;
+}
-- 
cgit v1.2.3