Skip to content

Instantly share code, notes, and snippets.

@sdumitriu
Created June 22, 2017 05:15
Show Gist options
  • Save sdumitriu/390a2c8abb7058c97cbd21e96553255e to your computer and use it in GitHub Desktop.
Save sdumitriu/390a2c8abb7058c97cbd21e96553255e to your computer and use it in GitHub Desktop.
Change tables to utf8 / utf8_bin
alter table LocalLoginToken convert to character set utf8 collate utf8_bin;
alter table PatientPushedToInfo convert to character set utf8 collate utf8_bin;
alter table PatientSourceServerInfo convert to character set utf8 collate utf8_bin;
alter table RemoteLoginData convert to character set utf8 collate utf8_bin;
alter table activitystream_events convert to character set utf8 collate utf8_bin;
alter table encryptedproperty convert to character set utf8 collate utf8_bin;
alter table feeds_aggregatorgroup convert to character set utf8 collate utf8_bin;
alter table feeds_aggregatorurl convert to character set utf8 collate utf8_bin;
alter table feeds_aggregatorurlgroups convert to character set utf8 collate utf8_bin;
alter table feeds_feedentry convert to character set utf8 collate utf8_bin;
alter table feeds_feedentrytags convert to character set utf8 collate utf8_bin;
alter table feeds_keyword convert to character set utf8 collate utf8_bin;
alter table mailsender_events convert to character set utf8 collate utf8_bin;
alter table xwikiattachment convert to character set utf8 collate utf8_bin;
alter table xwikiattachment_archive convert to character set utf8 collate utf8_bin;
alter table xwikiattachment_content convert to character set utf8 collate utf8_bin;
alter table xwikiattrecyclebin convert to character set utf8 collate utf8_bin;
alter table xwikicomments convert to character set utf8 collate utf8_bin;
alter table xwikidates convert to character set utf8 collate utf8_bin;
alter table xwikidbversion convert to character set utf8 collate utf8_bin;
alter table xwikidoc convert to character set utf8 collate utf8_bin;
alter table xwikidoubles convert to character set utf8 collate utf8_bin;
alter table xwikifloats convert to character set utf8 collate utf8_bin;
alter table xwikiid convert to character set utf8 collate utf8_bin;
alter table xwikiintegers convert to character set utf8 collate utf8_bin;
alter table xwikilargestrings convert to character set utf8 collate utf8_bin;
alter table xwikilinks convert to character set utf8 collate utf8_bin;
alter table xwikilistitems convert to character set utf8 collate utf8_bin;
alter table xwikilists convert to character set utf8 collate utf8_bin;
alter table xwikilock convert to character set utf8 collate utf8_bin;
alter table xwikilongs convert to character set utf8 collate utf8_bin;
alter table xwikiobjects convert to character set utf8 collate utf8_bin;
alter table xwikipreferences convert to character set utf8 collate utf8_bin;
alter table xwikiproperties convert to character set utf8 collate utf8_bin;
alter table xwikircs convert to character set utf8 collate utf8_bin;
alter table xwikirecyclebin convert to character set utf8 collate utf8_bin;
alter table xwikistatsdoc convert to character set utf8 collate utf8_bin;
alter table xwikistatsreferer convert to character set utf8 collate utf8_bin;
alter table xwikistatsvisit convert to character set utf8 collate utf8_bin;
alter table xwikistrings convert to character set utf8 collate utf8_bin;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment