R
R
Ravenenok2017-02-18 21:15:15
Yii
Ravenenok, 2017-02-18 21:15:15

Yii2 +PDO +MSSQL +macOS +XML?

There is a MSSQL database and there is a Mac on which I'm trying to access it from Yii2. With the first task of connecting, I coped by compiling the appropriate extensions for PHP, I can connect to the database and receive data.
But I have a piece of data in the database with the XML type, and if I simply request the output of this data, then the values ​​\u200b\u200bof all fields are returned, and the xml fields are returned empty.
If I do something with xquery I get a message

SQLSTATE[HY000]: General error: 20018 SELECT failed because the following SET options have incorrect settings: 'ANSI_NULLS, CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS, ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.

If I set these parameters in a query with xquery, then the error disappears, but the data is empty
Maybe someone came across?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question