note 34651 added to ref.mssql
| From: | xxpig at rack1 dot php dot net | 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