Coldfusion and MySQL

[mafioso1823]

I have coldfusion 5 enterprise & MySQL running on red hat linux 7.1. I have a database called Test. I am trying to write a script that will createa table but i keep getting the same error.


This is code that i have:

<cfif IsDefined(&quot;Form.Table&quot>

<cfquery name=&quot;MakeTable&quot; datasource=&quot;Test&quot;>
CREATE TABLE #Form.Table#
(
TestOne VARCHAR(255),
TestTwo VARCHAR(255)
)
</cfquery>

<cfelse>

<cfform action=&quot;#CGI.SCRIPT_NAME#&quot; method=&quot;Post&quot;>
<input type=&quot;text&quot; name=&quot;Table&quot;>
<input type=&quot;Submit&quot; value=&quot;Create&quot;>
</cfform>
</cfif>




Error that it keeps giving me:


ODBC Error Code = 60 ()


[MERANT][ODBC MySql driver][MySql]Too big column length for column 'TestOne' (max = 255). Use BLOB instead



The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:2) to (3:47).



And i tried to use a lower number and it still gave me that error, is there any to fix this?