check the postgresql database is UTF8 before allowing installation to proceed

1 files changed, 8 insertions, 0 deletions

diff --git a/install.php b/install.php
index 1d3a531c5..d5e8e8b61 100644
--- a/install.php
+++ b/install.php
@@ -243,6 +243,14 @@ function pgsql_db_installer($host, $database, $username, $password, $sitename) {
   updateStatus("Checking database...");
   $conn = pg_connect($connstring);
 
+  //ensure database encoding is UTF8
+  $record = pg_fetch_object(pg_query($conn, 'SHOW server_encoding'));
+  if ($record->server_encoding != 'UTF8') {
+    updateStatus("Laconica requires UTF8 character encoding. Your database is ". htmlentities($record->server_encoding));
+    showForm();
+    return false;
+  }
+
   updateStatus("Running database script...");
   //wrap in transaction;
   pg_query($conn, 'BEGIN');