Weird behavior with Unicode data

Savvas Kampouridis <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CAJEJLjRTaDxczkxH20J+TAeq47X-MqpnVO1y+Kwibm-VN8Gbfw@mail.gmail.com>
Hello everyone.

I have detected a rather weird behavior when I use FreeTDS with PHP on a
CentOS machine and perform a select on SQL Server 2012 on Unicode data. I
have nvarchar(50) columns that contain Unicode strings with variable
lengths. When any string has a length of more than 25, the driver does not
return the column data at all, returning an empty string instead.

I am using the latest FreeTDS driver with the latest unixODBC and I have
set the tds version to 8.0 and the client charset to utf-8. When the client
charset is not set the response is a lot of ??? which is probably logical.

Is there anything that anyone has in mind? I would happily provide any
additional info you might need.

Thanks in advance for any help that you might be able to provide.


Savvas Kampouridis
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.