pymssql: Problem with Unicode string

[Orgil]

Hello.
I can not get unicode string from MSSQL.
I have pymssql-1.0.2, freetds-0.82, ubuntu-10.10.
I have two computers.
First is well configured and good working (i did not configured). From
that computer, I can read the unicode.
Now i am trying to set up connection to mssql and reading unicode
string on second computer. I am trying to install and configure
freetds like first computer. But I can not do this.

When I run "$ locate freetds" from terminal on first computer (which
is good working one), the result is:
------------------------------------
/etc/freetds
/etc/freetds/freetds.conf
/usr/local/freetds
/usr/local/etc/freetds.conf
/usr/local/freetds/bin
/usr/local/freetds/etc
/usr/local/freetds/include
/usr/local/freetds/lib
/usr/local/freetds/man
/usr/local/freetds/share
/usr/local/freetds/bin/bsqldb
/usr/local/freetds/bin/bsqlodbc
/usr/local/freetds/bin/datacopy
/usr/local/freetds/bin/defncopy
/usr/local/freetds/bin/fisql
/usr/local/freetds/bin/freebcp
/usr/local/freetds/bin/osql
/usr/local/freetds/bin/tdspool
/usr/local/freetds/bin/tsql
/usr/local/freetds/etc/freetds.conf
/usr/local/freetds/etc/locales.conf
/usr/local/freetds/etc/pool.conf
/usr/local/freetds/include/bkpublic.h
/usr/local/freetds/include/cspublic.h
/usr/local/freetds/include/cstypes.h
/usr/local/freetds/include/ctpublic.h
/usr/local/freetds/include/sqldb.h
/usr/local/freetds/include/sqlfront.h
/usr/local/freetds/include/sybdb.h
/usr/local/freetds/include/syberror.h
/usr/local/freetds/include/sybfront.h
/usr/local/freetds/include/tds_sysdep_public.h
/usr/local/freetds/lib/libct.a
/usr/local/freetds/lib/libct.la
/usr/local/freetds/lib/libct.so
/usr/local/freetds/lib/libct.so.4
/usr/local/freetds/lib/libct.so.4.0.0
/usr/local/freetds/lib/libsybdb.a
/usr/local/freetds/lib/libsybdb.la
/usr/local/freetds/lib/libsybdb.so
/usr/local/freetds/lib/libsybdb.so.5
/usr/local/freetds/lib/libsybdb.so.5.0.0
/usr/local/freetds/lib/libtdsodbc.a
/usr/local/freetds/lib/libtdsodbc.la
/usr/local/freetds/lib/libtdsodbc.so
/usr/local/freetds/lib/libtdsodbc.so.0
/usr/local/freetds/lib/libtdsodbc.so.0.0.0
/usr/local/freetds/man/man1
/usr/local/freetds/man/man5
/usr/local/freetds/man/man1/bsqldb.1
/usr/local/freetds/man/man1/bsqlodbc.1
/usr/local/freetds/man/man1/datacopy.1
/usr/local/freetds/man/man1/defncopy.1
/usr/local/freetds/man/man1/fisql.1
/usr/local/freetds/man/man1/freebcp.1
/usr/local/freetds/man/man1/osql.1
/usr/local/freetds/man/man1/tsql.1
/usr/local/freetds/man/man5/freetds.conf.5
/usr/local/share/man/man5/freetds.conf.5
/var/cache/apt/archives/freetds-common_0.82-6build1_all.deb
/var/cache/apt/archives/freetds-dev_0.82-6build1_i386.deb
/var/lib/dpkg/info/freetds-common.list
/var/lib/dpkg/info/freetds-common.postrm
/var/tmp/freetds.conf.swp
----------------------------------

And when I do the same run second computer, result is:
----------------------------------
/etc/freetds
/etc/freetds.conf
/etc/freetds/freetds.conf
/home/usi/Downloads/freetds-stable.tgz
/usr/local/etc/freetds.conf
/usr/local/etc/freetds.conf.save
/usr/local/share/man/man5/freetds.conf.5
/usr/man/man5/freetds.conf.5
/usr/share/freetds
/usr/share/doc/freetds-common
/usr/share/doc/freetds-dev
/usr/share/doc/freetds-common/NEWS.gz
/usr/share/doc/freetds-common/README
/usr/share/doc/freetds-common/README.Debian
/usr/share/doc/freetds-common/TODO.Debian
/usr/share/doc/freetds-common/TODO.gz
/usr/share/doc/freetds-common/changelog.Debian.gz
/usr/share/doc/freetds-common/changelog.gz
/usr/share/doc/freetds-common/copyright
/usr/share/doc/freetds-common/examples
/usr/share/doc/freetds-common/examples/freetds.conf
/usr/share/doc/freetds-common/examples/freetds.conf.pl
/usr/share/doc/freetds-common/examples/locales.conf
/usr/share/doc/freetds-common/examples/odbcinst.ini
/usr/share/doc/freetds-dev/changelog.Debian.gz
/usr/share/doc/freetds-dev/changelog.gz
/usr/share/doc/freetds-dev/copyright
/usr/share/freetds/freetds.conf
/usr/share/man/man5/freetds.conf.5.gz
/var/cache/apt/archives/freetds-bin_0.82-7_i386.deb
/var/cache/apt/archives/freetds-common_0.82-7_all.deb
/var/cache/apt/archives/freetds-dev_0.82-7_i386.deb
/var/lib/dpkg/info/freetds-common.list
/var/lib/dpkg/info/freetds-common.md5sums
/var/lib/dpkg/info/freetds-common.postinst
/var/lib/dpkg/info/freetds-common.postrm
/var/lib/dpkg/info/freetds-dev.list
/var/lib/dpkg/info/freetds-dev.md5sums
/var/lib/dpkg/info/freetds-dev.preinst
-------------------------

As the results, there is so huge difference between two computers.
I can not install freetds as installed as on first computer!

How to install freetds as installed as on first computer?

Regards,
Orgil

[Adnan Sadzak]

You did not install static libs and headers

Try this:
aptitude install freetds-bin freetds-common freetds-dev

or just freetds-dev.

Cheers

> --
> You received this message because you are subscribed to the Google Groups "Django users" group.
> To post to this group, send email to django...@googlegroups.com.
> To unsubscribe from this group, send email to django-users...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
>
>

[Ramiro Morales]

On Wed, Feb 16, 2011 at 8:46 AM, Orgil <org...@gmail.com> wrote:
> Hello.
> I can not get unicode string from MSSQL.
> I have pymssql-1.0.2, freetds-0.82, ubuntu-10.10.

It seems you have sent this message to the wrong mailing list.

--
Ramiro Morales