From: ivan <ivan>
Date: Tue, 23 Apr 2002 07:10:19 +0000 (+0000)
Subject: fixes inserting strings that end in numbers to TEXT columns... gah i hate SQL
X-Git-Tag: freeside_1_4_0_pre12~26
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=62403391487a8e2d1518fa850ea27f15d466882b

fixes inserting strings that end in numbers to TEXT columns... gah i hate SQL
---

diff --git a/FS/FS/Record.pm b/FS/FS/Record.pm
index ac8117e70..f7c3a41c8 100644
--- a/FS/FS/Record.pm
+++ b/FS/FS/Record.pm
@@ -1155,7 +1155,7 @@ sub _quote {
   my($dbh)=dbh;
   if ( $value =~ /^\d+(\.\d+)?$/ && 
 #       ! ( datatype($table,$field) =~ /^char/ ) 
-       ! ( $dbdef->table($table)->column($field)->type =~ /(char|binary)$/i ) 
+       ! $dbdef->table($table)->column($field)->type =~ /(char|binary|text)$/i 
   ) {
     $value;
   } else {