note 34651 deleted from ref.mssql by sniper

Note Submitter: xxpig [AT] hotmail DOT com ---- 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.