
Hello DEV list, ATTN: All MSSQL Sepcialists! We need your help! We have a current problem with OTRS when running on MSSQL. An exact description of the problem is located at: http://bugs.otrs.org/show_bug.cgi?id=2227 The solution, as presented by Mortiz, functions great. The problem is: The solution requires that all core functions that use LIKE would need to be called using QuoteLike(). We view this change as unacceptable, due to the fact that the entire core must be overhauled to reflect this change, and that in all other modules that would be developed using the QuoteLike() call could be easily forgotten. With the exception of MSSQL, all DBMS's can handle a LIKE in this situation without problem. We would prefer a fix in the DBMS drivers within OTRS. Our preference would be to find a configurations option in MSSQL that would deactivate the behavior of square brackets in connection with the LIKE function. We could then send this option to MSSQL with the connection information. We were unsuccessful in finding anything of use in the MSSQL documentation. We have great interest in hearing if anyone knows a way to do this. Please contact us if you know anything that may help. Best regards, Manuel Hecht ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0)9421 56818 0 :: Fax: +49 (0)9421 56818 18 http://www.otrs.com/ :: Communication with success!
participants (1)
-
Manuel Hecht - OTRS AG