https://bugzilla.wikimedia.org/show_bug.cgi?id=47368
--- Comment #2 from Dario Taraborelli <[email protected]> --- Yuvi, I am not fully persuaded the charset should be consistent with MW's default binary. Other databases used for data analysis on s1 host datasets coming from various sources (squid logs, API, dumps) that make utf8 the ideal encoding. I typically rely on IDs for my work so I am probably less sensitive to this issue. Can you expand on the issues you're referring to in the original report? On a related note, the situation on s1 is pretty messy: SHOW CREATE DATABASE staging; +----------+--------------------------------------------------------------------+ | Database | Create Database | +----------+--------------------------------------------------------------------+ | staging | CREATE DATABASE `staging` /*!40100 DEFAULT CHARACTER SET latin1 */ | +----------+--------------------------------------------------------------------+ 1 row in set (0.03 sec) SHOW CREATE DATABASE prod; +----------+-----------------------------------------------------------------+ | Database | Create Database | +----------+-----------------------------------------------------------------+ | prod | CREATE DATABASE `prod` /*!40100 DEFAULT CHARACTER SET latin1 */ | +----------+-----------------------------------------------------------------+ 1 row in set (0.03 sec) SHOW CREATE DATABASE enwiki; +----------+-------------------------------------------------------------------+ | Database | Create Database | +----------+-------------------------------------------------------------------+ | enwiki | CREATE DATABASE `enwiki` /*!40100 DEFAULT CHARACTER SET binary */ | +----------+-------------------------------------------------------------------+ 1 row in set (0.03 sec) SHOW CREATE DATABASE log; +----------+--------------------------------------------------------------+ | Database | Create Database | +----------+--------------------------------------------------------------+ | log | CREATE DATABASE `log` /*!40100 DEFAULT CHARACTER SET utf8 */ | +----------+--------------------------------------------------------------+ 1 row in set (0.03 sec) -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
