Thank you Michael for the info, I'll try that out!
On May 11, 2009, at 11:03 AM, Michael Peppler wrote:
On May 6, 2009, at 10:06 PM, Peter Thoeny wrote:
Hi,
I stumbled on a roadblock and need some help.
I am trying to connect to a MS-SQL database using DBD::Sybase, http://search.cpan.org/~mewp/DBD-Sybase-1.09/dbd-sybase.pod
on Centos 5.2. The DBD::Sybase module is used from within the
DatabasePlugin of the TWiki Enterprise Collaboration Platform.
Connection works fine unless there are special characters such as
single quotes in the query result. With special characters, I get
this message: "Some character(s) could not be converted into
client's character set. Unconverted bytes were changed to question
marks ('?')."
If your client runs on CentOS it will most likely run in ISO8859-1
or in UTF-8.
The MS special chars are in CP1252, but not in ISO8859-1.
Setting the charset= attribute at the connection level is supported
by DBD::Sybase which simply hands this information off to the
underlying library. When using Sybase ClientLibrary the charsets are
well-defined, and you could specify cp1252 to tell OpenClient not to
perform any conversions.
I don't know how FreeTDS handles the charset conversions - you may
wish to post this to the freetds mailing list to get a better answer.
Michael
--
Michael Peppler - Peppler Consulting
SaRL
[email protected] - http://www.peppler.org
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com
Sybase on Linux FAQ - http://www.peppler.org/FAQ/linux.html
--
* Peter Thoeny, CTO - peter.thoeny.public[at]twiki.net
* http://twiki.net - TWIKI.NET - Enterprise Collaboration
* http://twiki.org - is your team already TWiki enabled?
* Knowledge cannot be managed, it can be discovered and shared
* This e-mail is: (_) private (x) ask first (_) public
