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 | |
---|
20 | namespace Doctrine\DBAL\Platforms; |
---|
21 | |
---|
22 | /** |
---|
23 | * Platform to ensure compatibility of Doctrine with SQLServer2005 version and |
---|
24 | * higher. |
---|
25 | * |
---|
26 | * Differences to SQL Server 2008 are: |
---|
27 | * |
---|
28 | * - DATETIME2 datatype does not exist, only DATETIME which has a precision of |
---|
29 | * 3. This is not supported by PHP DateTime, so we are emulating it by |
---|
30 | * setting .000 manually. |
---|
31 | * - Starting with SQLServer2005 VARCHAR(MAX), VARBINARY(MAX) and |
---|
32 | * NVARCHAR(max) replace the old TEXT, NTEXT and IMAGE types. See |
---|
33 | * {@link http://www.sql-server-helper.com/faq/sql-server-2005-varchar-max-p01.aspx} |
---|
34 | * for more information. |
---|
35 | */ |
---|
36 | class SQLServer2005Platform extends SQLServerPlatform |
---|
37 | { |
---|
38 | /** |
---|
39 | * @override |
---|
40 | */ |
---|
41 | public function supportsLimitOffset() |
---|
42 | { |
---|
43 | return true; |
---|
44 | } |
---|
45 | |
---|
46 | /** @override */ |
---|
47 | public function getClobTypeDeclarationSQL(array $field) |
---|
48 | { |
---|
49 | return 'VARCHAR(MAX)'; |
---|
50 | } |
---|
51 | } |
---|
52 | |
---|