OrmCAST TEXT type? -label:question

[camexapps]

Hi there (awseome module by the way) just wondering if there is a cast type that is set for TEXT, MEDIUMTEXT etc?

[WebEP]

Hi,

No, as you can see here, all the types we currently are providing : https://github.com/besstiolle/orm-ms/blob/master/src/Orm/lib/class.OrmCAST.php.

Do you need these types to be added?

[camexapps]

Yes, please. That would be great if you wouldn't mind... also TinyInt too

[besstiolle]

should it be more logic to let "integer" as the default value and proposing tinyint / bigint / ... according to the size of the "integer" field ?

I would avoid implementing too much new type of field. (eg : more code, duplicate tests, ...)

[camexapps]

Thats a great idea

[besstiolle]

After some work on this subject, here my response :

Due to limitation of ADODB http://phplens.com/lens/adodb/docs-datadict.htm

STRING :

• C: Varchar, capped to 255 characters.
• X: Larger varchar, capped to 4000 characters (to be compatible with Oracle). (it's our BUFFER)

INTEGER :

• I: Integer (mapped to I4)
• I1: 1-byte integer
• I2: 2-byte integer
• I4: 4-byte integer
• I8: 8-byte integer

So you won't be able to map your field on MEDIUMTEXT but we will be able to manage TINYINT, SMALLINT, INT, BIGINT. The MySqL Type MEDIUMINT is not implemented due to the ADODB limitation

See more doc on it : https://github.com/besstiolle/orm-ms/wiki/Cast (it's not already implemented on GIT)