projects
/
migration-tools.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
(parent:
6a91d9c
)
default charset and collate for csv2mysql
author
Jason Etheridge
<jason@equinoxinitiative.org>
Thu, 16 Apr 2020 14:36:45 +0000 (10:36 -0400)
committer
Jason Etheridge
<jason@equinoxinitiative.org>
Thu, 16 Apr 2020 14:36:45 +0000 (10:36 -0400)
Signed-off-by: Jason Etheridge <jason@equinoxinitiative.org>
kmig.d/bin/csv2mysql
patch
|
blob
|
history
diff --git
a/kmig.d/bin/csv2mysql
b/kmig.d/bin/csv2mysql
index
840126a
..
6359c8c
100755
(executable)
--- 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 }) {