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”
Category: Perl
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');