From 89d0b316d9aa07b7bd14f80b21ceb55725c46a22 Mon Sep 17 00:00:00 2001
From: Jason Etheridge <jason@equinoxinitiative.org>
Date: Thu, 16 Apr 2020 10:36:45 -0400
Subject: [PATCH] default charset and collate for csv2mysql

Signed-off-by: Jason Etheridge <jason@equinoxinitiative.org>
---
 kmig.d/bin/csv2mysql |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/kmig.d/bin/csv2mysql b/kmig.d/bin/csv2mysql
index 840126a..6359c8c 100755
--- a/kmig.d/bin/csv2mysql
+++ b/kmig.d/bin/csv2mysql
@@ -100,7 +100,7 @@ sub write_sql_table {
     } else {
 	    $cfg->{table_name} = 'm_' . lc(basename($fn)); $cfg->{table_name} =~ s/[\-\. ]/_/g;
 	    print $sql "DROP TABLE IF EXISTS $cfg->{table_name};\n";
-	    print $sql "CREATE TABLE $cfg->{table_name} (x_migrate BOOLEAN);\n";
+	    print $sql "CREATE TABLE $cfg->{table_name} (x_migrate BOOLEAN) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\n";
     }
     push @indices, 'x_migrate';
 	foreach my $column (@{ $info }) {
-- 
1.7.2.5