Add mysql utf8 collation, new lookup functions

[umlisp.git] / create-sql.lisp

diff --git a/create-sql.lisp b/create-sql.lisp
index 88fa898fb89814d881ec3b1c6b3fbe551551fc02..544267c4037b2efb1789afc27cedeaac912ebc90 100644 (file)
--- a/create-sql.lisp
+++ b/create-sql.lisp
@@ -44,7 +44,7 @@
                 " MAX_ROWS=200000000"
               "")
             (if (eq *umls-sql-type* :mysql)
-                " TYPE=MYISAM CHARACTER SET utf8"
+                " TYPE=MYISAM CHARACTER SET utf8 COLLATE utf8_bin"
                 ""))))
 
 (defun create-custom-table-cmd (tablename sql-cmd)