From 5a68f0998ca5015c621787b2c8982f2cea03c26d Mon Sep 17 00:00:00 2001
From: Frédéric Buclin <LpSolit@gmail.com>
Date: Tue, 21 Aug 2012 00:42:22 +0200
Subject: Bug 783786: PostgreSQL databases can be created with the wrong
 encoding r=dkl a=LpSolit

---
 Bugzilla/DB/Schema/Pg.pm | 10 ++++++++++
 1 file changed, 10 insertions(+)

(limited to 'Bugzilla/DB')

diff --git a/Bugzilla/DB/Schema/Pg.pm b/Bugzilla/DB/Schema/Pg.pm
index ffe97e109..3dc0fe85e 100644
--- a/Bugzilla/DB/Schema/Pg.pm
+++ b/Bugzilla/DB/Schema/Pg.pm
@@ -74,6 +74,16 @@ sub _initialize {
 } #eosub--_initialize
 #--------------------------------------------------------------------
 
+sub get_create_database_sql {
+    my ($self, $name) = @_;
+    # We only create as utf8 if we have no params (meaning we're doing
+    # a new installation) or if the utf8 param is on.
+    my $create_utf8 = Bugzilla->params->{'utf8'}
+                      || !defined Bugzilla->params->{'utf8'};
+    my $charset = $create_utf8 ? "ENCODING 'UTF8' TEMPLATE template0" : '';
+    return ("CREATE DATABASE $name $charset");
+}
+
 sub get_rename_column_ddl {
     my ($self, $table, $old_name, $new_name) = @_;
     if (lc($old_name) eq lc($new_name)) {
-- 
cgit v1.2.3-24-g4f1b