Issue Bug Closed

#25960Some DB fields needs to be varchar to support MSSQL

Sonja Schubert 04/14/11, 11:58 updated 10/02/18, 12:20

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.