From 8efab06616bfcdab49fb9e996cdc7ddfe79426bb Mon Sep 17 00:00:00 2001
From: Michael Foster <savetheinternet@tinyboard.org>
Date: Tue, 30 Jul 2013 22:08:56 -0400
Subject: Upgrade to utf8mb4 charset for MySQL server versions above 5.5.3.
 Keep support for older versions. Fix charsets for multiple columns and
 tables.

---
 post.php | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'post.php')

diff --git a/post.php b/post.php
index e9041ce8..d1749fd1 100644
--- a/post.php
+++ b/post.php
@@ -378,7 +378,10 @@ if (isset($_POST['delete'])) {
 		
 	wordfilters($post['body']);
 	
-	$post['body_nomarkup'] = preg_replace('/[\x{010000}-\x{ffffff}]/u', '', $post['body']);
+	if (mysql_version() >= 50503)
+		$post['body_nomarkup'] = $post['body']; // Assume we're using the utf8mb4 charset
+	else
+		$post['body_nomarkup'] = preg_replace('/[\x{010000}-\x{ffffff}]/u', '', $post['body']); // MySQL's `utf8` charset only supports up to 3-byte symbols
 	
 	if (!($mod && isset($post['raw']) && $post['raw']))
 		$post['tracked_cites'] = markup($post['body'], true);
-- 
cgit v1.3