Image data type is stored as nvarchar(255) instead of image

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hello,

I noticed a bug in SuiteCRM 7.2 beta.

When a field is created in Studio with a data type “image”, the data type stored in the database (I am using MSSQL) is nvarchar(255) instead of image.

See attached.

If you change it to “image” in SQL Management Studio, SuiteCRM gives the error “database failure” when you try to save a contact.

I think selecting a data type “image” in Studio should create a data type “image” in SQL.

Thanks for all of your hard work on SuiteCRM, it really is fantastic.

2

The image is saved in the upload directory as a file with hex and decimals that must match the database data

Best regards