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



-----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: 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: unicode conversion
    ... It is not a perl problem, ... In theory, on an utf8 terminal with locale set to an utf8-enabled status, ... breaks utf8 output of Chinese characters to an otherwise perfectly utf8- ... be fine if a complex Perl script could do all its data processing, ...
    (comp.lang.perl.misc)
  • Re: ANNOUNCE: DBD:Oracle 1.18
    ... Well a warning in one compiler is better than and error in an other so I ... This might be a problem more with the older oracle OCI in your client. ... perl -Mblib t/26exe_array.t ...
    (perl.dbi.users)