1 files changed, 5 insertions, 1 deletions
diff --git a/admin/include/functions.php b/admin/include/functions.php
index 076c69fb4..4dd2869ef 100644
--- a/admin/include/functions.php
+++ b/admin/include/functions.php
@@ -743,7 +743,7 @@ UPDATE '.$tablename.'
   {
     // creation of the temporary table
     $query = '
-DESCRIBE '.$tablename.'
+SHOW FULL COLUMNS FROM '.$tablename.'
 ;';
     $result = pwg_query($query);
     $columns = array();
@@ -762,6 +762,10 @@ DESCRIBE '.$tablename.'
         {
           $column.= " default '".$row['Default']."'";
         }
+        if (isset($row['Collation']))
+        {
+          $column.= " collate '".$row['Collation']."'";
+        }
         array_push($columns, $column);
       }
     }