This content has been marked as final. Show 4 replies
Not really. The variable will be created by default as varchar(). If you need longtext, you need to change them manually in the db like you mentioned.
A very early version of Workflow had a variable type of "text", which equatetd to a longtext. It's a real pain not having it, and I can only imagine that it would be reasonably easy to add it.
Please request this feature enhancment through support, and maybe we'll see it in the next version.
After some research and trial and error I have found out how LC maps its string variables to MySQL datatypes.
* 1 <= n <= 255 ==> varchar(n) [ 2^8 - 1]
* 256 <= n <= 65.535 ==> text [2^16 - 1]
* 65536 <= n <= 4.294.967.295 ==> longtext [2^32 - 1]
Note: If you reduce the length of a string, the data type will not be changed.
If you set the size to -1, I believe it'll create a column of type "clob" in which case you won't have to worry with the size.