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

šŸ’¬ 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