From d1acf00b8b8ca67e1ba1855041a55b7ee6d7db74 Mon Sep 17 00:00:00 2001
From: brettp <brettp@36083f99-b078-4883-b0ff-0f9b5a30f544>
Date: Wed, 7 Oct 2009 21:44:27 +0000
Subject: Fixes #1181: UTF8 now correctly stored in database.

git-svn-id: http://code.elgg.org/elgg/trunk@3514 36083f99-b078-4883-b0ff-0f9b5a30f544
---
 engine/schema/upgrades/2009100701.sql | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)
 create mode 100644 engine/schema/upgrades/2009100701.sql

(limited to 'engine/schema/upgrades/2009100701.sql')

diff --git a/engine/schema/upgrades/2009100701.sql b/engine/schema/upgrades/2009100701.sql
new file mode 100644
index 000000000..f84096a94
--- /dev/null
+++ b/engine/schema/upgrades/2009100701.sql
@@ -0,0 +1,19 @@
+SET NAMES utf8;
+
+REPLACE INTO `prefix_metastrings` (id, string) 
+	SELECT id, unhex(hex(convert(string using latin1))) 
+	FROM `prefix_metastrings`;
+
+REPLACE INTO `prefix_groups_entity` (guid, name, description) 
+	SELECT guid, unhex(hex(convert(name using latin1))), unhex(hex(convert(description using latin1)))
+	FROM `prefix_groups_entity`;
+
+REPLACE INTO `prefix_objects_entity` (guid, title, description)
+	SELECT guid, unhex(hex(convert(title using latin1))), unhex(hex(convert(description using latin1)))
+	FROM `prefix_objects_entity`;
+
+REPLACE INTO `prefix_users_entity` (guid, name, username, password, salt, email, language, code, 
+	banned, last_action, prev_last_action, last_login, prev_last_login)
+		SELECT guid, unhex(hex(convert(name using latin1))), username, password, salt, email, language, code,
+			banned, last_action, prev_last_action, last_login, prev_last_login
+		FROM `prefix_users_entity`;
-- 
cgit v1.2.3

