Software / code / prosody
Changeset
5918:06106726a1f0
util.sql: Get character set info from the correct database.
| author | Kim Alvefur <zash@zash.se> |
|---|---|
| date | Tue, 12 Nov 2013 11:13:45 +0100 |
| parents | 5916:1c4405f33561 |
| children | 5919:d1cc67ed0767 |
| files | util/sql.lua |
| diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/util/sql.lua Tue Nov 12 02:23:02 2013 +0000 +++ b/util/sql.lua Tue Nov 12 11:13:45 2013 +0100 @@ -308,7 +308,7 @@ 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;
