RE: Special characters
- From: Philip.Garrett@xxxxxxxxxxx (Philip Garrett)
- Date: Tue, 21 Aug 2007 14:29:00 -0400
Oracle's IAS globalization guide is pretty helpful in understanding the interplay of Oracle, Perl and the web environment:
http://www.oracle.com/technology/tech/globalization/pdf/globalization-best-practices.PDF
It was written for 9i, but most of it still applies to 10g, I believe.
- Philip
Dan King wrote:
I am having issues running a web application, called OTRS, that uses
DBI and DBD::Oracle. When I insert special characters, such as é or â
they show up as question marks in the database when looking at them
from sqlplus or through the web application. I am running the web app
on Apache v1 with an Oracle 10g backend.
I have been able to successfully insert and read the special
characters using sqlplus from the command line of the server running
the web app, apache and Oracle as well as creating a small perl test
script that looks as follows:
#!/usr/local/bin/perl
use warnings;
use strict;
use Data::Dumper;
use DBI;
use DBD::Oracle;
my $dbh = DBI->connect("dbi:Oracle:host=localhost;sid=QAT",
"rm_ticket", "rm_ticket");
my $sql = qq{ UPDATE signature SET text='çè' WHERE id=1 };
my $sth = $dbh->prepare($sql);
$sth->execute();
$sth->finish();
$dbh->disconnect;
The reading script looks as follows:
#!/usr/local/bin/perl
use warnings;
use strict;
use Data::Dumper;
use DBI;
use DBD::Oracle;
my $dbh = DBI->connect("dbi:Oracle:host=localhost;sid=QAT",
"rm_ticket", "rm_ticket");
my $sql = qq{ SELECT text from signature };
my $sth = $dbh->prepare($sql);
$sth->execute();
my($text);
$sth->bind_columns(undef, \$text);
print "Text of signature:\n\n";
while( $sth->fetch() ) {
print "Object: $text\n";
}
$sth->finish();
$dbh->disconnect;
Does anyone know why I can successfully write and read from the
database when I am not using the web application but when I use the
web application the special characters fail to work properly?
Dan King
Software Developer
Canadian Resident Matching Service
613.237.0075 ext. 241
(Toll free) 877.CARMS.42
171 Nepean Street, Suite 300
Ottawa, ON, CAN K2P 0B4
www.carms.ca <http://www.carms.ca>
------------------------------------------------------------------------------------
This e-mail message, including any attachments, is for the sole use
of the intended recipients and may contain confidential and or
privileged information. If you are not the intended recipient or
this information has been forwarded in error, please contact the
sender by reply e-mail and destroy copies of the original message.
Ce message (incluant toute pièce jointe) s'adresse uniquement au(x)
destinataire(s) prévu(s) ou à une personne autorisée à le recevoir en
son (leur) nom. Il pourrait contenir des renseignements confidentiels
ou protégés. Si vous l'avez reçu par erreur, nous vous prions d'en
informer l'auteur dans les meilleurs délais, de ne pas divulguer son
contenu et de le supprimer de votre système. Merci.
.
- References:
- Special characters
- From: Dan King
- Special characters
- Prev by Date: RE: Special characters
- Next by Date: Re: (Fwd) Re: DBD::Oracle won't install for Oracle 10G XE
- Previous by thread: RE: Special characters
- Next by thread: RE: Special characters
- Index(es):
Relevant Pages
|
|
