note 105843 added to function.mssql-query
| From: | MSSQLNewbie at osu1 dot php dot net | Date: | Mon, 19 Sep 2011 20:34:48 +0000 |
| Subject: | note 105843 added to function.mssql-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-183279@lists.php.net to get a copy of this message | ||
Here are some things you might need to know:
1. Install mssql support for Debian (Lenny/Squeeze):
apt-get install php5-sybase
2. When you got this error message:
"Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using
DB-Library (such as ISQL) or ODBC version 3.7 or earlier."
In /etc/freetds/freetds.conf add these two lines (last two):
[global]
;tds version = 4.2
tds version = 8.0
client charset = UTF-8
You can edit "charset" in php.ini too (but you don't need if you did it previously in
freetds.conf):
; Specify client character set..
; If empty or not set the client charset from freetds.comf is used
; This is only used when compiled with FreeTDS
mssql.charset = "UTF-8"
3. Use nchar/nvarchar/ntext column types if you need unicode support.
----
Server IP: 69.147.83.197
Probable Submitter: 94.248.129.7
----
Manual Page -- http://www.php.net/manual/en/function.mssql-query.php
Edit -- https://master.php.net/note/edit/105843
Del: integrated -- https://master.php.net/note/delete/105843/integrated
Del: useless -- https://master.php.net/note/delete/105843/useless
Del: bad code -- https://master.php.net/note/delete/105843/bad+code
Del: spam -- https://master.php.net/note/delete/105843/spam
Del: non-english -- https://master.php.net/note/delete/105843/non-english
Del: in docs -- https://master.php.net/note/delete/105843/in+docs
Del: other reasons-- https://master.php.net/note/delete/105843
Reject -- https://master.php.net/note/reject/105843
Search -- https://master.php.net/manage/user-notes.php