diff options
author | brettp <brettp@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2009-10-07 21:44:27 +0000 |
---|---|---|
committer | brettp <brettp@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2009-10-07 21:44:27 +0000 |
commit | d1acf00b8b8ca67e1ba1855041a55b7ee6d7db74 (patch) | |
tree | f795ca153a5e25952fd2564f3da0ad77b894fe57 /engine/schema | |
parent | fc11e5260309702e3301837e3725fe8084b61a4e (diff) | |
download | elgg-d1acf00b8b8ca67e1ba1855041a55b7ee6d7db74.tar.gz elgg-d1acf00b8b8ca67e1ba1855041a55b7ee6d7db74.tar.bz2 |
Fixes #1181: UTF8 now correctly stored in database.
git-svn-id: http://code.elgg.org/elgg/trunk@3514 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine/schema')
-rw-r--r-- | engine/schema/upgrades/2009100701.sql | 19 |
1 files changed, 19 insertions, 0 deletions
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`; |