We have installed OTRS on a FEDORA box and it’s working great with /mysql/ but we want to connect OTRS with MSSQL.
I guess you won't succeed due to the available data types in MSSQL. Iirc, it's this:
We need huge, searchable(!) TEXT fields (or varchar). MSSQL doesn't allow text data types to be bigger than 4096 byte, above this you have to use BLOBs and stuff, which aren't indexable nor searchable (correct me if I'm wrong). So, every email above 4k will blow your installation.
Nonetheless, we had this discussion to some extent on this list. Search the archives please, and come back with more questions arizing.
Regards,
Robert Kehl _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/
