Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re: UTF-8, Oracle and Perl life

by wardk (Deacon)
on Oct 07, 2002 at 19:33 UTC ( #203462=note: print w/ replies, xml ) Need Help??


in reply to UTF-8, Oracle and Perl life

Haven't worked with Japanese, but I have experienced Perl/Oraperl issues with Oracle related to character sets.

My only advice would be to ensure that you have the following Oracle environment settings set in your Perl environment prior to connecting

ORA_NLS ORA_NLS33 NLS_LANG
this can be done via the following (your values will obviously differ)
$ENV{ORA_NLS}="/opt/oracle/product/8.1.7/migrate/nls/admin/data"; $ENV{ORA_NLS33}="/opt/oracle/product/8.1.7/migrate/nls/admin/data"; $ENV{NLS_LANG}="AMERICAN_AMERICA.US7ASCII";
Hope this is helpful...good luck!


Comment on Re: UTF-8, Oracle and Perl life
Select or Download Code
Re: Re: UTF-8, Oracle and Perl life
by Akira71 (Scribe) on Oct 07, 2002 at 19:40 UTC
    Actually the database in Oracle is setup and functioning correctly in UTF-8 through the ORA_NLS. The application we wrote using various web service technologies (except for anything .NET :-) ) works wonderfully. It is only the extract we have with problems with.

    In answer to the other reply above, yes we are using Oraperl. I was told we could not upgrade anything on the box originally. However, I did identify the possibility that Oraperl is to blame and have found the right Unix admin to add DBD:Oracle to the system so we can use it. Unfortunately the box is on the other part of the world for us, so this takes time for us to implement. Admitedly this is one of my only foray's into Perl and I love what I see so far. I am a C++ / Java person and now this has my interest totally.

    Thank you for support and helpful hints!

    Akira

      Is your current extract script either setting the vars I mentioned or inheriting them from the calling environment? for instance, if the job is running from cron, you will absolutely need to set this in the perl script. This is independent from the database setup, and your perl won't inherit the settings from Oracle. They will need to be in the calling environment (set perhaps in a calling shell script) or setting them specifically in the perl.
        Actually they are inheriting them from the database so no, we are not setting them in the perl script. I can add the appropriate ones to the perl script.

        I will try that and see if it helps.

        Thank you,

        Akira

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://203462]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (9)
As of 2014-09-24 05:51 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (246 votes), past polls