SQLServer2005Platform.php 1.8 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152
  1. <?php
  2. /*
  3. * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
  4. * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
  5. * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
  6. * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
  7. * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
  8. * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
  9. * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
  10. * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
  11. * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
  12. * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
  13. * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
  14. *
  15. * This software consists of voluntary contributions made by many individuals
  16. * and is licensed under the LGPL. For more information, see
  17. * <http://www.doctrine-project.org>.
  18. */
  19. namespace Doctrine\DBAL\Platforms;
  20. /**
  21. * Platform to ensure compatibility of Doctrine with SQLServer2005 version and
  22. * higher.
  23. *
  24. * Differences to SQL Server 2008 are:
  25. *
  26. * - DATETIME2 datatype does not exist, only DATETIME which has a precision of
  27. * 3. This is not supported by PHP DateTime, so we are emulating it by
  28. * setting .000 manually.
  29. * - Starting with SQLServer2005 VARCHAR(MAX), VARBINARY(MAX) and
  30. * NVARCHAR(max) replace the old TEXT, NTEXT and IMAGE types. See
  31. * {@link http://www.sql-server-helper.com/faq/sql-server-2005-varchar-max-p01.aspx}
  32. * for more information.
  33. */
  34. class SQLServer2005Platform extends SQLServerPlatform
  35. {
  36. /**
  37. * @override
  38. */
  39. public function supportsLimitOffset()
  40. {
  41. return true;
  42. }
  43. /** @override */
  44. public function getClobTypeDeclarationSQL(array $field)
  45. {
  46. return 'VARCHAR(MAX)';
  47. }
  48. }