#25960Some DB fields needs to be varchar to support MSSQL
Description
There are some fields in the sys_workspace table, which are of type text at the moment. This is a problem for MSSQL, as MSSQL is not able to compare type text fields in a query like “adminusers = ‘5’”.
Solution is to change the types of these three fields (adminusers, members, reviewers) to varchar(4000). Tested in a MSSQL database and a MySQL database, works for both.
I will attach a patch soon.
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.