freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
[freetds] Connection to SQL2000 - Unicode data in a Unicode-only collation
- From: Wilson Mak <wilson.mak AT digitalview.com>
- To: freetds AT lists.ibiblio.org
- Subject: [freetds] Connection to SQL2000 - Unicode data in a Unicode-only collation
- Date: Wed, 21 Sep 2005 18:44:07 +0800
Hi all,
I want to connect to a SQL2000 server, however, during the connection, I got an error as below:
# tsql -S 10.1.0.200:1433 -U sa -I /etc/freetds.conf
locale is "en_US.UTF-8"
locale charset is "UTF-8"
Password:
1> use TEST
2> go
1> select * from ITEM
2> go
Msg 4004, Level 16, State 1, Server SQLSERVER, Line 1
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.
1>
Here is the freedts.conf:
[SQLSERVER]
host = 10.1.0.200
port = 1433
tds version = 7.0
try server logins = yes
client charset = UTF-8
What other stuffs do i need to set to make it work?
P.S I can broswe some tables! Weird!
Thanks in advance,
Wilson
-
[freetds] Connection to SQL2000 - Unicode data in a Unicode-only collation,
Wilson Mak, 09/21/2005
-
Re: [freetds] Connection to SQL2000 - Unicode data in a Unicode-only collation,
Christos Zoulas, 09/21/2005
-
Re: [freetds] Connection to SQL2000 - Unicode data in a Unicode-only collation,
Wilson Mak, 09/22/2005
- Re: [freetds] Connection to SQL2000 - Unicode data in a Unicode-only collation, Christos Zoulas, 09/22/2005
-
Re: [freetds] Connection to SQL2000 - Unicode data in a Unicode-only collation,
Daniel Fazekas, 09/22/2005
- Re: [freetds] Connection to SQL2000 - Unicode data in a Unicode-only collation, Wilson Mak, 09/22/2005
-
Re: [freetds] Connection to SQL2000 - Unicode data in a Unicode-only collation,
Wilson Mak, 09/22/2005
-
Re: [freetds] Connection to SQL2000 - Unicode data in a Unicode-only collation,
Christos Zoulas, 09/21/2005
Archive powered by MHonArc 2.6.24.