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 ('?')."
Reading the docs it looks like I can turn this off if I specify the
proper character set when connecting to the database. I verified, the
MS-SQL uses Code Page (ISO) 1252.
I tried "charset=1252" and "charset=windows-1252" and a bunch of other
variations, but I can't get rid of the error.
Any hint? Any other detail you need? See below error output.
Regards,
Peter
DBD::Sybase::st fetchrow_hashref failed: OpenClient? message: LAYER =
(0) ORIGIN = (0) SEVERITY = (9) NUMBER = (99) Server , database
Message String: WARNING! Some character(s) could not be converted into
client's character set. Unconverted bytes were changed to question
marks ('?'). at /var/www/twiki/lib/TWiki/Plugins/DatabasePlugin/
DATABASE_SQL.pm line 19
TWiki
::Plugins
::DatabasePlugin
::DATABASE_SQL
::handle('TWiki::Plugins::DatabasePlugin::Connection=HASH(0x8fda120)',
'description="MyData" sql="SELECT Overview from CompanyInfo? ...')
called at /var/www/twiki/lib/TWiki/Plugins/DatabasePlugin.pm line 81
eval {...} called at /var/www/twiki/lib/TWiki/Plugins/
DatabasePlugin.pm line 75
TWiki::Plugins::DatabasePlugin::_dispatch('DATABASE_SQL',
'description="MyData" sql="SELECT Overview from CompanyInfo? ...')
called at /var/www/twiki/lib/TWiki/Plugins/DatabasePlugin.pm line 98
TWiki::Plugins::DatabasePlugin::commonTagsHandler('\x{a}
%...', 'TestSqlComapnyDescription', 'Sandbox', 0,
'TWiki::Meta=HASH(0x901ae98)') called at /var/www/twiki/lib/TWiki/
Plugin.pm line 266
TWiki::Plugin::invoke('TWiki::Plugin=HASH(0x889a440)',
'commonTagsHandler', '\x{a}
%...', 'TestSqlComapnyDescription', 'Sandbox', 0,
'TWiki::Meta=HASH(0x901ae98)') called at /var/www/twiki/lib/TWiki/
Plugins.pm line 344
TWiki::Plugins::_dispatch('TWiki::Plugins=HASH(0x83d8348)',
'commonTagsHandler', '\x{a}
%...', 'TestSqlComapnyDescription', 'Sandbox', 0,
'TWiki::Meta=HASH(0x901ae98)') called at /var/www/twiki/lib/TWiki/
Plugins.pm line 480
TWiki::Plugins::commonTagsHandler('TWiki::Plugins=HASH(0x83d8348)',
'\x{a}
--
* Peter Thoeny, CTO - [email protected]
* http://twiki.net - TWIKI.NET - the Enterprise Wiki
* 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
