How to Get XML From Database – Simple Perl Script

Although Perl is relatively old programming language and there should be plenty of reference available online – I still find it challenging to write something new in Perl because of it’s unusual syntax and many ways of doing the same thing.
Here is a simple script to get XML from database.
Continue reading “How to Get XML From Database – Simple Perl Script”

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');