From c8166108d5f372baecc198e5e8d3a1d38ffd641c Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Mon, 4 Jun 2007 02:46:49 +0000 Subject: [PATCH] r1556: Add another check on the table column conversions to ensure that it's only text and char data that we're converting --- install/convert_database_charset.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/install/convert_database_charset.php b/install/convert_database_charset.php index eae65d0..8b5e448 100644 --- a/install/convert_database_charset.php +++ b/install/convert_database_charset.php @@ -112,7 +112,7 @@ else if ($bugsys->in['step'] == 3) $columns = $db->query("SHOW FULL COLUMNS FROM $table[0]"); while ($col = $db->fetch_array($columns)) { - if (!is_null($col['Collation'])) + if (!is_null($col['Collation']) AND (strpos($col['Type'], 'char') !== false OR strpos($col['Type'], 'text') !== false)) { $db->query("ALTER TABLE $table[0] MODIFY $col[Field] $col[Type] COLLATE " . TARGET); $admin->row_text($table[0], $col['Field']); -- 2.22.5