Ticket Details

SQL Server 2000?

RFC Ticket (closed) 

Since PHP has finally released the mssql extension, I was thinking about creating the `MSSql` Adapter for Lithium.

Also, Microsoft has [their own extension](http://msdn.microsoft.com/en-us/library/ee229548%28SQL.10%29.aspx) available for PHP which could use its own adapter.

After giving some thought to this, I am left with a good question: __Should we support SQL Server 2000 in Lithium?__

- Mainstream support ended on 2008-04-08
- Extended support is good through 2013-04-09
- Microsoft's own PHP driver does not support SQL Server 2000

Some new features of SQL Server 2005/2008 are:

- `varchar(max)`, `nvarchar(max)`, and `varbinary(max)` were introduced to prevent the 8K/rec limitation
- `text` datatype has been deprecated in favor of `varchar(max)` which acts like `text`, but is string-function friendly
- `ROW_NUMBER()` was implemented which could simplify the pagination process to 2 `SELECT` statements

I would like to hear community comments on this before I start on the adapter, as the comments may influence the design a bit.
on 12.14.09 reported by: schreck84 owned by: jperras

Updates

on 12.14.09 by jperras 
I say nay on the SQL Server 2000 support. We're not supporting older releases of PHP, so supporting SQL Server 2000 shouldn't be a priority for us.

Moreover, not supporting the 2000 release means that we can use the official MSSQL Windows driver, which is leaps & bounds ahead of what was available before.
(wont-fix) on 01.06.10 by jperras
  • owner was changed to jperras
  • status was changed to closed
  • resolution was changed to wont-fix
We are **not** going to support SQL Server 2000 in the core.

However, we **will** have an SQL Server 2008 adapter in the core.