Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- unicode via DBI on linux to sql server 2005?
February 28, 2008, 2:03 pm
rate this thread
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?
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
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...
- » FAQ 4.36 How can I expand variables in text strings?
- — Previous thread in » PERL Discussions