aboutsummaryrefslogtreecommitdiffstats
path: root/util
diff options
context:
space:
mode:
authorKim Alvefur <zash@zash.se>2013-11-12 11:13:45 +0100
committerKim Alvefur <zash@zash.se>2013-11-12 11:13:45 +0100
commit72140f4dd6bc76ea3970582e513bea1a9dde07a1 (patch)
treed4aff0b2df96e4c6cb9cdff6285802fb4ad2435a /util
parentab1d24c6f58b53cc3a868579c30655ea1369d965 (diff)
downloadprosody-72140f4dd6bc76ea3970582e513bea1a9dde07a1.tar.gz
prosody-72140f4dd6bc76ea3970582e513bea1a9dde07a1.zip
util.sql: Get character set info from the correct database.
Diffstat (limited to 'util')
-rw-r--r--util/sql.lua2
1 files changed, 1 insertions, 1 deletions
diff --git a/util/sql.lua b/util/sql.lua
index a7f46421..5e441c10 100644
--- a/util/sql.lua
+++ b/util/sql.lua
@@ -308,7 +308,7 @@ function engine:set_encoding() -- to UTF-8
if driver == "MySQL" then
set_names_query = set_names_query:gsub(";$", " COLLATE 'utf8_bin';");
local ok, charsets = self:transaction(function()
- return self:select"SELECT `CHARACTER_SET_NAME` FROM `CHARACTER_SETS` WHERE `CHARACTER_SET_NAME` LIKE 'utf8%' ORDER BY MAXLEN DESC LIMIT 1;";
+ return self:select"SELECT `CHARACTER_SET_NAME` FROM `CHARACTER_SETS` WHERE `information_schema`.`CHARACTER_SET_NAME` LIKE 'utf8%' ORDER BY MAXLEN DESC LIMIT 1;";
end);
local row = ok and charsets();
charset = row and row[1] or charset;