diff options
| -rw-r--r-- | tools/fix_utf8.py | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/tools/fix_utf8.py b/tools/fix_utf8.py new file mode 100644 index 0000000..18cc206 --- /dev/null +++ b/tools/fix_utf8.py @@ -0,0 +1,21 @@ +#! /usr/bin/env python +import MySQLdb + +host = "localhost" +passwd = "h1NRFheXVS9crbm3" +user = "sj_main" +dbname = "sj_main" + +db = MySQLdb.connect(host=host, user=user, passwd=passwd, db=dbname) +cursor = db.cursor() + +cursor.execute("ALTER DATABASE `%s` CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci'" % dbname) + +sql = "SELECT DISTINCT(table_name) FROM information_schema.columns WHERE table_schema = '%s'" % dbname +cursor.execute(sql) + +results = cursor.fetchall() +for row in results: + sql = "ALTER TABLE `%s` convert to character set DEFAULT COLLATE DEFAULT" % (row[0]) + cursor.execute(sql) +db.close() |