[SOLVED] TEXT fields still wrongly created as BLOB (version 9.12.019)

Scriptcase 9 General
#1

With a query like this and log_text being a MEDIUMTEXT field:

SELECT 
     log_text,  
     cast(log_text AS CHAR) AS cast_as_field,
FROM 
     prj_log

SC will create these fields in a grid:

  • log_text as MEDIUMTEXT
  • cast_as_field as LONG_BLOB

So a CAST to CHAR with no size is still converted to a BLOB.
It should be converted to LONGTEXT.

DB is mariadb

#2

@robydago,

The case in question has already been reported and is under review.

As soon as there are updates on the matter, we’ll provide feedback here in this thread.

Best regards!

#3

@robydago,

A fix for this issue was released in version 9.12.021, which is now available for download/update.

If possible, check if the issue has been fixed.

Best regards!