commit cb60ca13a9cb98f6ce16e010543e95db498009b3
author Rushabh Mehta <rmehta@gmail.com> Mon Jan 16 11:58:14 2012 +0530
committer Rushabh Mehta <rmehta@gmail.com> Mon Jan 16 11:58:14 2012 +0530
tree 635d179183388ba3c44d176ec9c820e5853b9245
parent 610f9728ab3b6d08f734af4010a09efe2e4de4ac

added patch to convert tables to utf8

erpnext/patches/jan_mar_2012/convert_tables_to_utf8.py

diff --git a/erpnext/patches/jan_mar_2012/convert_tables_to_utf8.py b/erpnext/patches/jan_mar_2012/convert_tables_to_utf8.py
new file mode 100644
index 0000000..1ae94a7
--- /dev/null
+++ b/erpnext/patches/jan_mar_2012/convert_tables_to_utf8.py
@@ -0,0 +1,11 @@
+import webnotes
+
+def execute():
+	sql = webnotes.conn.sql
+	
+	sql("commit")
+	sql("set foreign_key_checks=0")
+	for tab in sql("show tables"):
+		sql("ALTER TABLE `%s` CONVERT TO CHARACTER SET utf8" % tab[0])
+
+	sql("set foreign_key_checks=1")