diff options
author | Oren Hurvitz | 2014-04-23 16:18:28 +0300 |
---|---|---|
committer | Oren Hurvitz | 2014-04-23 16:18:28 +0300 |
commit | 2c9859314f72cfa32358c43bc47a668ec62af008 (patch) | |
tree | c88fe9ab85ae8912eca1042b09197af258e138dd /OpenSim/Data/MySQL/Resources/IM_Store.migrations | |
parent | Reverting test change to cause another email (diff) | |
download | opensim-SC_OLD-2c9859314f72cfa32358c43bc47a668ec62af008.zip opensim-SC_OLD-2c9859314f72cfa32358c43bc47a668ec62af008.tar.gz opensim-SC_OLD-2c9859314f72cfa32358c43bc47a668ec62af008.tar.bz2 opensim-SC_OLD-2c9859314f72cfa32358c43bc47a668ec62af008.tar.xz |
Changed table 'im_offline' to use UTF8 characters. This fixes a problem with Offline IM V2 (only relevant to MySQL).
This fixes http://opensimulator.org/mantis/view.php?id=7123
Users that use MySQL should change their MySQL configuration to support UTF8. In the config file /etc/my.cnf (Linux) or my.ini (Windows), add these settings:
[mysqld]
character-set-server=utf8
[client]
default-character-set=utf8
And then restart MySQL (on Linux: "sudo service mysqld restart").
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/IM_Store.migrations | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/OpenSim/Data/MySQL/Resources/IM_Store.migrations b/OpenSim/Data/MySQL/Resources/IM_Store.migrations index f73475e..79ead98 100644 --- a/OpenSim/Data/MySQL/Resources/IM_Store.migrations +++ b/OpenSim/Data/MySQL/Resources/IM_Store.migrations | |||
@@ -1,4 +1,4 @@ | |||
1 | :VERSION 1 # -------------------------- | 1 | :VERSION 1 # -------------------------- |
2 | 2 | ||
3 | BEGIN; | 3 | BEGIN; |
4 | 4 | ||
@@ -32,3 +32,11 @@ ALTER TABLE `im_offline` | |||
32 | ADD KEY `FromID` (`FromID`); | 32 | ADD KEY `FromID` (`FromID`); |
33 | 33 | ||
34 | COMMIT; | 34 | COMMIT; |
35 | |||
36 | :VERSION 4 # -------------------------- | ||
37 | |||
38 | BEGIN; | ||
39 | |||
40 | ALTER TABLE im_offline CONVERT TO CHARACTER SET utf8; | ||
41 | |||
42 | COMMIT; | ||