> -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of Noah Kantrowitz > > He would still need to make a Trac DB plugin to manage that backend.
Ahh, of course. I haven't been drinking enough coffee today ! > It probably wouldn't be that hard to write though, just look > a the 3 existing ones. True, the a backend for MSSQL can be built from the 3 existing ones. However, some SQL rewrites are required such as * LENGTH -> LEN * LIMIT -> TOP * || -> + (String concat) * Ordering by Boolean expressions -> Order by CASE returning 0 or 1 Also, use NVARCHAR(MAX) on MSSQL 2005 instead of text as MSSQL handles that better. However, indexes can not be build on nvarchar fields larger then 4000 characters so if the column is a key/index the field should by nvarchar(4000) or smaller. Cheers, Bjorn Swift --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users -~----------~----~----~----~------~----~------~--~---
