RE: Special characters

Ah sorry, the OS is Solaris 9 sparc.

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

------------------------------------------------------------------------------------

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.


-----Original Message-----
From: Rutherdale, Will [mailto:Will.Rutherdale@xxxxxxxxxx]
Sent: August 21, 2007 2:01 PM
To: dbi-users@xxxxxxxx
Subject: RE: Special characters

I'm not experienced with this exact issue in particular, but you might find you're running under a different user ID with your test program than with your web application.

You didn't specify what OS you're using or whether you're using Apache. However from my experience in web vs. command-line Perl apps, I'd suggest first dumping the environment variables, i.e. %ENV, and the current user id from each test program. You may find important differences.

Oracle experts on the list might be able to give you more specifics.

-Will


-----Original Message-----
From: Dan King [mailto:DKing@xxxxxxxx]
Sent: Tuesday 21 August 2007 13:33
To: dbi-users@xxxxxxxx
Subject: Special characters


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.







- - - - - Appended by Scientific Atlanta, a Cisco company - - - - -
This e-mail and any attachments may contain information which is confidential,
proprietary, privileged or otherwise protected by law. The information is solely
intended for the named addressee (or a person responsible for delivering it to
the addressee). If you are not the intended recipient of this message, you are
not authorized to read, print, retain, copy or disseminate this message or any
part of it. If you have received this e-mail in error, please notify the sender
immediately by return e-mail and delete it from your computer.




.