Informix mis calculates max length of integer fields

[TomChiverton]

Index: /home/chivertont/Projects/reactor/trunk/data/informix/ObjectDao.cfc
===================================================================
--- /home/chivertont/Projects/reactor/trunk/data/informix/ObjectDao.cfc (revision 3983)
+++ /home/chivertont/Projects/reactor/trunk/data/informix/ObjectDao.cfc (working copy)
@@ -99,7 +99,11 @@

<!--- field length for text fields is held as 56 in the db, but text can be 2^{31 or space available on disk, whichever is less --->
<cfif qFields.dbDataType NEQ 12>}

- <cfset Field.length = qFields.length />
+ <cfif qFields.dbDataType eq 2><!--- for integer is length in bits --->
+ <cfset Field.length = len(2⁽⁽²(qFields.length+1))-1)) >
+ <cfelse>
+ <cfset Field.length = qFields.length />
+ </cfif>

<cfelse>

<cfset Field.length = 2147483648>

</cfif>

[TomChiverton]

Trac didn't like me putting the patch in the summary, sorry