From 122492940dba8a299f006ddaa91a77cc536b9383 Mon Sep 17 00:00:00 2001
From: Kurund Jalmi <kurund.jalmi@gmail.com>
Date: Mon, 25 Jul 2022 17:19:17 +0100
Subject: [PATCH] export error fixes for multi-select contact reference custom
 field

---
 CRM/Export/BAO/ExportProcessor.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/CRM/Export/BAO/ExportProcessor.php b/CRM/Export/BAO/ExportProcessor.php
index 18a5663ff8..263931c27b 100644
--- a/CRM/Export/BAO/ExportProcessor.php
+++ b/CRM/Export/BAO/ExportProcessor.php
@@ -1456,7 +1456,7 @@ class CRM_Export_BAO_ExportProcessor {
         case CRM_Utils_Type::T_INT:
         case CRM_Utils_Type::T_BOOLEAN:
           if (in_array(CRM_Utils_Array::value('data_type', $fieldSpec), ['Country', 'StateProvince', 'ContactReference'])) {
-            return "`$fieldName` varchar(255)";
+            return "`$fieldName` text";
           }
           // some of those will be exported as a (localisable) string
           // @see https://lab.civicrm.org/dev/core/-/issues/2164
-- 
2.25.1