Charset & "use utf8" bei UTF-8-encodierten Datenbankupgradescripten gefixt

diff --git a/sql/Pg-upgrade2/SKR04-3804-addition.pl b/sql/Pg-upgrade2/SKR04-3804-addition.pl
index 56136d004b52d541b31020be5d1df9a991228071..23630765f12d38def833ba326b2b86b0123ac66f 100644 (file)
--- a/sql/Pg-upgrade2/SKR04-3804-addition.pl
+++ b/sql/Pg-upgrade2/SKR04-3804-addition.pl
@@ -3,6 +3,7 @@
 # @depends:
 # @charset: UTF-8
 
+use utf8;
 use strict;
 
 die("This script cannot be run from the command line.") unless ($main::form);

diff --git a/sql/Pg-upgrade2/add_more_constraints_fibu_projekt_xplace.pl b/sql/Pg-upgrade2/add_more_constraints_fibu_projekt_xplace.pl
index dd3705caa817e5dac59ec0fe1b61cb31b1676308..c9c720b0c609ab17b526e4001c9a8df9420b4c3b 100644 (file)
--- a/sql/Pg-upgrade2/add_more_constraints_fibu_projekt_xplace.pl
+++ b/sql/Pg-upgrade2/add_more_constraints_fibu_projekt_xplace.pl
@@ -3,6 +3,7 @@
 # @depends: release_2_6_0 fix_acc_trans_ap_taxkey_bug
 # @charset: utf-8
 
+use utf8;
 use strict;
 use Data::Dumper;
 die("This script cannot be run from the command line.") unless ($main::form);

diff --git a/sql/Pg-upgrade2/auth_enable_sales_all_edit.pl b/sql/Pg-upgrade2/auth_enable_sales_all_edit.pl
index e77fbee65382a2f3c41007dde45551d2da4538f5..c6101e664624a460323c2a980fab61478b06edac 100644 (file)
--- a/sql/Pg-upgrade2/auth_enable_sales_all_edit.pl
+++ b/sql/Pg-upgrade2/auth_enable_sales_all_edit.pl
@@ -3,6 +3,7 @@
 # @depends: release_2_6_0
 # @charset: utf-8
 
+use utf8;
 use strict;
 use Data::Dumper;
 die("This script cannot be run from the command line.") unless ($main::form);

diff --git a/sql/Pg-upgrade2/buchungsgruppen_sortkey.sql b/sql/Pg-upgrade2/buchungsgruppen_sortkey.sql
index c78ee8973944691cf72d210f032afccca85e9800..a04835d0bc1722fae8af055f20a501cf4d040b59 100644 (file)
--- a/sql/Pg-upgrade2/buchungsgruppen_sortkey.sql
+++ b/sql/Pg-upgrade2/buchungsgruppen_sortkey.sql
@@ -1,6 +1,7 @@
 -- @tag: buchungsgruppen_sortkey
--- @description: Neue Spalte für Sortierreihenfolge der Buchungsgruppen
+-- @description: Neue Spalte für Sortierreihenfolge der Buchungsgruppen
 -- @depends: release_2_4_1
+-- @charset: utf-8
 ALTER TABLE buchungsgruppen ADD COLUMN sortkey integer;
 CREATE SEQUENCE tmp_counter;
 UPDATE buchungsgruppen SET sortkey = nextval('tmp_counter');

diff --git a/sql/Pg-upgrade2/customer_long_entries.sql b/sql/Pg-upgrade2/customer_long_entries.sql
index 2412449408b2ae24742baf9c18f80561a5703879..d2c6b9214e5d366b4f0f7639f2d1b2b6d86e8620 100644 (file)
--- a/sql/Pg-upgrade2/customer_long_entries.sql
+++ b/sql/Pg-upgrade2/customer_long_entries.sql
@@ -1,6 +1,7 @@
 -- @tag: customer_long_entries
 -- @description: Lange Spalten für Kundentabelle
 -- @depends: release_2_6_1
+-- @charset: utf-8
 
 ALTER TABLE customer ALTER COLUMN account_number TYPE text;
 ALTER TABLE customer ALTER COLUMN bank_code TYPE text;

diff --git a/sql/Pg-upgrade2/rundungsfehler_korrigieren_BUG1328.pl b/sql/Pg-upgrade2/rundungsfehler_korrigieren_BUG1328.pl
index b7dadb484776d69840b7f9823a133e8162a32c30..1e9b00d08c4a987cc3130e3781910d5223ba6545 100644 (file)
--- a/sql/Pg-upgrade2/rundungsfehler_korrigieren_BUG1328.pl
+++ b/sql/Pg-upgrade2/rundungsfehler_korrigieren_BUG1328.pl
@@ -3,6 +3,7 @@
 # @depends: release_2_6_0
 # @charset: utf-8
 
+use utf8;
 use strict;
 use Data::Dumper;
 die("This script cannot be run from the command line.") unless ($main::form);

diff --git a/sql/Pg-upgrade2/warehouse_add_bestbefore.sql b/sql/Pg-upgrade2/warehouse_add_bestbefore.sql
index 325a9a327a2f6e90cb5d0aa31e65b42d69e004af..4e58d4debebef34198870f81a158fef44faaf044 100644 (file)
--- a/sql/Pg-upgrade2/warehouse_add_bestbefore.sql
+++ b/sql/Pg-upgrade2/warehouse_add_bestbefore.sql
@@ -1,5 +1,6 @@
 -- @tag: warehouse_add_bestbefore
 -- @description: Spalten für Mindesthaltbarkeitsdatum
 -- @depends: release_2_6_0
+-- @charset: utf-8
 ALTER TABLE inventory ADD COLUMN bestbefore date;
 ALTER TABLE delivery_order_items_stock ADD COLUMN bestbefore date;