Extending a Datatype of LONG???

[GregLanders]

How can set a column of datatype long to accept more that 65000 characters. I see in the documentation that this datatype will hold up to 2GB but when I try to stick in more than 65000 characters, the data gets truncated. Anyone know what I am doing wrong?

 

[karluk]

How are you trying to enter the data into your long column? Different methods have diffent size limits.

 

[GregLanders]

I am using a ColdFusion query, something like this:

<cfquery datasource=&quot;#application.dsn#&quot; name=&quot;ins&quot;>
   insert into tablename
   (id,longdata_field)
   values('#createUUID()#','#variables.longdata#')
</cfquery>

Does this tell you anything?

 

[GregLanders]

Thank you, but I found the setting in the ColdFusion Administrator...