unicode via DBI on linux to sql server 2005?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I'm not really sure which forum to post this on!

I am attempting to retrieve data from an sql server 2005 database, hosted,
store and manipulated on a Windows box.

My code is running on a Linux box, and I have been given
read-only access to the DB server.

Connection via DBI is working well, but I am failing
to extract unicode data from the DB, which I understand
from googling is stored internally as UCS2.
(I can get ascii data and numeric data fine)

I am using perl, DBI, and the DBD::Sybase driver.

So - has anyone retrieved "international" data
in the same (or similar) circumstances as this?


Re: unicode via DBI on linux to sql server 2005?

bugbear wrote:
Quoted text here. Click to load it

Ye - me! It turns out the client character
set, into which the connection attempts to encode
the data, is NOT set from the DBI connection string


i.e. charset=utf-8

but in the freedts.conf file, which is part of the connection.


as the "client charset" parameter.

So I added

         client charset = UTF8

And my code did what I needed.

Hoping this helps someone else...


Site Timeline