note 34651 added to ref.mssql

From: Date: Sat, 02 Aug 2003 05:53:04 +0000
Subject: note 34651 added to ref.mssql
Groups: php.notes 
Request: Send a blank email to php-notes+get-53189@lists.php.net to get a copy of this message
I cannot use Chinese in SQL when connect to MSSQL 2000 Server using FreeTDS for a long time. And now, I have solved the problem. Many documents said that using --with-tdsver=7.0 to compile FreeTDS, becuase the default version of tds use 5.0 protocol and the default port of 5.0 is 4000, the default port of 7.0 is 1433, equal to MSSQL's port. I found that --with-tdsver=4.2 also use the port 1433, and the lower protocol can use Chinese! May be 7.0 need to use UNICODE, and 4.2 don't use it. If you had already compiled FreeTDS --with-tdsver=7.0, you can also set an enviroment as: set TDSVER=4.2; export TDSVER Then you can connect to MSSQL2000 and using Chinese in the query. ---- Manual Page -- http://www.php.net/manual/en/ref.mssql.php Edit Note -- http://master.php.net/manage/user-notes.php?action=edit+34651 Delete Note -- http://master.php.net/manage/user-notes.php?action=delete+34651&report=yes Reject Note -- http://master.php.net/manage/user-notes.php?action=reject+34651&report=yes

« previous php.notes (#53189) next »