4 Jan
2005
4 Jan
'05
11:19 a.m.
Integrity IT - Sebastian Seghete schrieb:
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