Answer the question
In order to leave comments, you need to log in
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.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question