prosody
06106726a1f0
util/sql.lua

Find changesets by keywords by author, files, the commit message, revision number or hash, or revset expression.

Software / code / prosody

Comparison

util/sql.lua @ 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
parent 5912:f6145e894569
child 5919:d1cc67ed0767
comparison
equal deleted inserted replaced
5916:1c4405f33561 5918:06106726a1f0
306 local set_names_query = "SET NAMES '%s';" 306 local set_names_query = "SET NAMES '%s';"
307 local charset = "utf8"; 307 local charset = "utf8";
308 if driver == "MySQL" then 308 if driver == "MySQL" then
309 set_names_query = set_names_query:gsub(";$", " COLLATE 'utf8_bin';"); 309 set_names_query = set_names_query:gsub(";$", " COLLATE 'utf8_bin';");
310 local ok, charsets = self:transaction(function() 310 local ok, charsets = self:transaction(function()
311 return self:select"SELECT `CHARACTER_SET_NAME` FROM `CHARACTER_SETS` WHERE `CHARACTER_SET_NAME` LIKE 'utf8%' ORDER BY MAXLEN DESC LIMIT 1;"; 311 return self:select"SELECT `CHARACTER_SET_NAME` FROM `CHARACTER_SETS` WHERE `information_schema`.`CHARACTER_SET_NAME` LIKE 'utf8%' ORDER BY MAXLEN DESC LIMIT 1;";
312 end); 312 end);
313 local row = ok and charsets(); 313 local row = ok and charsets();
314 charset = row and row[1] or charset; 314 charset = row and row[1] or charset;
315 end 315 end
316 self.charset = charset; 316 self.charset = charset;