Re: [DBI-Users] UTF-8 issues connecting to Oracle



Hello again

I've got the problem solved, thanks to all that helped.

After all the other issues were solved, it was simply that the query returned no rows. D'oh.

Cheers

Mike

On Jan 29, 2008, at 1:33 AM, Hermann Schwaerzler wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hello

Michael Muratet wrote:
[...]
I set the LANG='utf8' again and now I'm seeing:

perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = "utf8",
LC_ALL = "utf8",
LANG = "utf8"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").

check if "locale -a" really outputs a locale named "utf8" as being
installed on your system. more likely it is "es_US.utf8" or something
similar. you have to use this when you set LANG!

you probably know that in order to set the character-set for the
communication with the oracle database-server you have to set NLS_LANG
accordingly before starting the perl-program that does the connection?
e.g. NLS_LANG=american_america.AL32UTF8 for utf8!

regards
hermann schwärzler
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHntbZpZ4QdpzGMxwRAriLAKDR7D66aUYtBIJ7DVynhdQ1UJZu3gCg45LH
jxKMEUQ+3fAdZbws6TaAsz0=
=xzbW
-----END PGP SIGNATURE-----

.



Relevant Pages

  • Re: [DBI-Users] UTF-8 issues connecting to Oracle
    ... perl: warning: Setting locale failed. ... LANG = "utf8" ... you have to use this when you set LANG! ...
    (perl.dbi.users)
  • Re: Reading a Unicode text file
    ... are displayed as junk boxes in Unicode. ... happening from thin air, all I have is an abscure warning, something ... Perl and not your terminal--nine time out of ten, ... why you're setting:utf8 on both input and output. ...
    (perl.beginners)
  • Re: Problem in terminal, darwin
    ... perl: warning: Setting locale failed. ... try to set LANG to en_US.UTF-8 instead of UTF-8. ...
    (freebsd-questions)
  • Re: Wide character in print?
    ... Wide character in %s (W utf8) Perl met a wide character when it wasn't expecting one. ... This warning is by default on for I/O. ...
    (perl.beginners)
  • Re: problems with LC_ALL
    ... perl: warning: Setting locale failed. ... Please check the output of "locale" and then set LANG to ...
    (freebsd-stable)