Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

DBIx::Class converting values with umlaut

by loudstil (Initiate)
on Jul 02, 2014 at 15:11 UTC ( [id://1092010]=perlquestion: print w/replies, xml ) Need Help??

loudstil has asked for the wisdom of the Perl Monks concerning the following question:

Hi, I'm using DBIx::Class to fetch data from Oracle (11.2). when the data fetched, for example "Alfred Kärcher" its returns the value as "Alfred Karcher". I tried to add the $ENV NLS_LANG and NLS_NCHAR but still no change. I also used the utf8 module to verify that the data is utf8 encoded. Thanks in advance, Loudstil
  • Comment on DBIx::Class converting values with umlaut

Replies are listed 'Best First'.
Re: DBIx::Class converting values with umlaut
by kennethk (Abbot) on Jul 02, 2014 at 16:31 UTC
    What I've found works well for UTF-8 I/O for Oracle is: 
    $ENV{NLS_LANG} = 'AMERICAN_AMERICA.AL32UTF8';
my $db = DBI->connect(  $dbid,
                        $source_user,
                        $source_pass,
                        {
                            PrintError  => 0,
                            RaiseError  => 1,
                            AutoCommit  => 0,
                            ora_charset => 'AL32UTF8',
                        },
                    );

    [download]
    How does this compare to the values you use?

    #11929 First ask yourself `How would I do this without a computer?' Then have the computer do it the same way.

[reply]
[d/l]
Re: DBIx::Class converting values with umlaut
by jellisii2 (Hermit) on Jul 02, 2014 at 16:06 UTC
    This may be relevant.
[reply]
Re: DBIx::Class converting values with umlaut
by pajout (Curate) on Jul 03, 2014 at 14:47 UTC
    Just another hint: Additionally check if output string (perl variable) has utf8 flag set, because not-flagged but properly encoded utf8 string can be easily misunderstood by perl in some cases.
[reply]

Back to Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: perlquestion [id://1092010]
Approved by marto
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others musing on the Monastery: (5)
As of 2024-04-16 12:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found