And again: news from the obstruse borders of modern technology. You want to load characters into or read them out from Oracle with Perl, Perl DBI and DBD-Oracle. Non-ASCII characters will be mangled by this, unless your perl script is using the same coding system as the Oracle server. You can find out what's going on in your server with select * from V$NLS_PARAMETERS. Then you set the environment variables for perl, for example with $ENV{NLS_LANG} = "american_america.we8iso8859p1"; $ENV{ORA_NLS} = "$ENV{ORACLE_HOME}/ocommon/nls/admin/data";.
Find out all about the wonderful world of Perl DBD at dbi.perl.org.
No comments:
Post a Comment