Skip to content

Instantly share code, notes, and snippets.

View tafid's full-sized avatar

Andrii Klochok tafid

54 followers · 29 following
  • HiQDev
  • Kiev, Ukraine
View GitHub Profile
@tafid
tafid / How to convert an entire MySQL database characterset and collation to UTF-8?
Created November 28, 2016 13:44
ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
@tafid
tafid / How do I see what character set a MySQL database, table, column is?
Created November 28, 2016 13:45
SHOW FULL COLUMNS FROM table_name;