[2012-11-20] SQL Server in default language that isn't English causes problems

[sminnee]

created by: @halkyon (sharvey)
created at: 2012-11-20
original ticket: http://open.silverstripe.org/ticket/8040
second "original" ticket: silverstripe/silverstripe-framework#1647

---

See http://www.silverstripe.org/installing-silverstripe/show/21394?start=8#post318246 for more details.

In this case, the default language of SQL Server isn't set to English, and because of this, date values in the format of Y-m-d H:i:s get mis-converted when queried, causing an "out of bounds" error.

Localisation at the database level isn't required for !SilverStripe, so it's possible we can set the language of the database to English once the connection is established in !MSSQLDatabase::__construct()