Project

General

Profile

Actions
Copy link

Bug #25960

closed

Some DB fields needs to be varchar to support MSSQL

Added by Sonja Schubert over 13 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Must have
Assignee:
Sonja Schubert
Category:
Workspaces
Target version:
-
Start date:
2011-04-14
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

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.

Files

_25960.patch (694 Bytes) _25960.patch Sonja Schubert, 2011-04-14 12:08
Actions
Copy link

Also available in: Atom PDF