Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery

Re: Re: Re: UTF-8, Oracle and Perl life

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

in reply to Re: Re: UTF-8, Oracle and Perl life
in thread UTF-8, Oracle and Perl life

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.
  • Comment on Re: Re: Re: UTF-8, Oracle and Perl life

Replies are listed 'Best First'.
Re: Re: Re: Re: UTF-8, Oracle and Perl life
by Akira71 (Scribe) on Oct 07, 2002 at 20:05 UTC
    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,


      Actually they are inheriting them from the database
      No they're not. NLS settings are not cascaded, they are set individually for each client and server. Use NLS_LANG="JAPANESE_JAPAN.UTF8" for each of your clients. Either on the command line (or in the script) for a *nix box or in the registry for MS clients.


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://203472]
[Lotus1]: at least ticks don't fly
[1nickt]: We have a new tick in cenral New Jersey this year. The Lone Star tick -- no Lyme, but will give you an allergy to red meat!
[Your Mother]: "Tick Twister."
[1nickt]: My sister lives in the Sydney suburbs (carved out of the bush) and they have the Paralysis tick -- leavs you quadriplegic!
[perldigious]: Hmm, thanks Lotus1... perldigious scribbles note to buy lots of opossums as "pets" in the future to hang around outside his property. :-P
[1nickt]: You must twist and pull! If you burn, use tea tree oil etc, the tick barfs (inside your blood vessel) and you get all the loevely bacteria in his gut transferred to yours.
[1nickt]: tweesers work just fine
[hippo]: Hope everyone else is enjoying their lunch too.
[1nickt]: However, note that it takes between 2 and 4 hours for a tick to be able to start transmitting bacteria. So even if it has burrowed in and started eating, if you get it soon you should be OK.
[perldigious]: 1nickt: No more red meat! It would be more humane to just kill you, wouldn't it! :-)

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (14)
As of 2017-05-24 13:08 GMT
Find Nodes?
    Voting Booth?