m_mysql: null empty columns instead of setting to ''

1 files changed, 9 insertions, 1 deletions

diff --git a/modules/extra/m_mysql.cpp b/modules/extra/m_mysql.cpp
index 06cce3143..67e43fcdb 100644
--- a/modules/extra/m_mysql.cpp
+++ b/modules/extra/m_mysql.cpp
@@ -446,7 +446,15 @@ Query MySQLService::BuildInsert(const Anope::string &table, unsigned int id, Dat
 	{
 		Anope::string buf;
 		*it->second >> buf;
-		query.SetValue(it->first, buf);
+
+		bool escape = true;
+		if (buf.empty())
+		{
+			buf = "NULL";
+			escape = false;
+		}
+
+		query.SetValue(it->first, buf, escape);
 	}
 	
 	return query;