I spent a few day with patching LinuxMCE database connection to pass UTF8 option to the server. But without luck. However I found a way to configure mysql server to skip client’s request about charset and send all data in the defined one. To do that just add following lines in the my.cnf file under mysqld section: [mysqld] init_connect=’SET NAMES utf8; SET collation_connection = utf8_general_ci;’ […]
Traffic jams map with camera view from Yandex
Russian company Yandex which offers a lot of useful services and has Google’s vision of the web business (IMHO) recently announced Moscow map map with traffic jams and live cameras view! That’s really cool service and I didn’t see anything similar before. Additionally there are panoramic views. Similar as Google has. I’m waiting when the live cameras will be added for St. Petersburg. Or at […]
Perl, C++, mysql and UTF8
Recently I finished with Russian translation of LinuxMCE UI. But as I know now it was the easiest part. After addition Russian descriptions in the database I faced with problem of displaying them. I made a research and found following. To have UTF8 data in the mysql database a few steps should be done: default charset for server should be set to utf8 in the […]
IMDB::Film v0.42 is out!
I just released a new version of IMDB::Film – 0.42. Following changes were done since previous version: added retrieving of plot keywords for the film; fixed issue with retrieving of movie’s plot contained links; fixed issue with displaying special HTML symbols; added test for the plot keywords; fixed POD documentation. To implement correct displaying of special HTML symbols two new modules were added into dependencies […]
Add history and auto-complete to the SQL*Plus
I was very surprised how pure the Oracle’s command line utility SQL*Plus. Comparing with mysql it lack history, completion and doesn’t allow even edit query. To fix that the utility rlwrap can be used. I installed it via yum under Fedora 11 and run like that: rlwrap sqlplus db_user@db To have auto-complete feature you should find file SQL.dict somewhere (drop the comment, please, if you […]
Oracle date format and Perl
Oracle has its own date format – DD-MM-YY (24-sep-09). So, to insert a value into Oracle date field you should somehow convert date from your format. Sure it can be done using some date/time module or your own function. But there are two simpler ways – set desire date/time format for session or use Oracle date conversion function. To set specific date/time format for the […]
Connect to Oracle DB from Perl script
After successful installation of DBD::Oracle it’s time to use it. The connection string is the same as for he rest DB: my $dbi = DBI->connect(“dbi:Oracle:$db_name:$db_host:$db_port”, $db_user, $db_pass); As result of running code above I got following error: Couldn’t connect to database db_name: ORA-12154: TNS:could not resolve the connect identifier specified (DBD ERROR: OCIServerAttach) After googling I found that the problem was that. I tried to […]
Installing DBD::Oracle under Fedora 11
Recently I got a task which needs to communicate with database Oracle from Perl. Perl has an excellent database abstraction interface DBI. But for specific database it needs a driver – DBD module. To install DBD::Oracle you have to perform following simple steps: Download and install oracle-instantclient11.2-basic and oracle-instantclient11.2-devel RPMs from Instant Client Downloads for Linux x86 page. Export ORACLE_HOME: export ORACLE_HOME=/usr/lib/oracle/11.2/client/ Install DBD::Oracle using […]