Quotes and Perl Script

Recently I encountered problem that some characters weren’t displayed correctly on a web page generated by CGI script – when I ran it in unix console I got following message:

Some character(s) could not be converted into client’s character set. Unconverted bytes were changed to question marks (‘?’)

It appeared all I needed to do is to explicitly set the character set when I create Sybase instance with DBSETLCHARSET:

$dbh = new Sybase::DBlib $user, $pwd, $server, DBSETLCHARSET('UTF-8');