I'm connecting to SQL server from Linux environment using PHP with help of FreeTDS library. And looks like some connection parameters are being explicitly turned off. Specifically, somewhere in the process these are being ran:
set quoted_identifier off
set ansi_warnings off
set ansi_padding off
set ansi_nulls off
set concat_null_yields_null off
How can I adjust connection parameters globally (either on PHP level or on FreeTDS level) to set all of the above to ON, without having to change any of the applications on the server in any way?
EDIT:
Tried suggestion with odbc.ini, does not seem to work.
Here's my freetds.conf:
[Servername]
host = hostname.example.com
port = 1433
tds version = 7.0
timeout 3600 client charset UTF-8 text size 64512
odbc.ini:
AnsiNPW = YES
QuotedID = YES
odbcinst.ini is empty