Mailing-List: contact modperl-help@perl.apache.org; run by ezmlm
Precedence: bulk
Received-SPF: pass (nike.apache.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Special characters
Date: Tue, 21 Aug 2007 15:08:49 -0400
Message-ID: <7DAB75BDD6C28542ACA1E47D081BB0A03A42BC@carms-sbs.CaRMS.local>
In-Reply-To: <000301c7e425$955d96d0$fca8a8c0@CaRMS.local>
Thread-Topic: Special characters
thread-index: AcfkJZVdXtTUH+GvSFqQ69OPbGjxOQAAPe1g
References: <7DAB75BDD6C28542ACA1E47D081BB0A03A42B2@carms-sbs.CaRMS.local>
 <000301c7e425$955d96d0$fca8a8c0@CaRMS.local>
From: "Dan King" <DKing@carms.ca>
Cc: <modperl@perl.apache.org>

I am using ISO-8859-1 in the database and the correct encoding is being =
used on the clients web browser. That is why I thought that it may be an =
apache or mod_perl issue.

Thank you for the recommendations though and I will look into and =
experiment with all of them.

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=E8ce jointe) s'adresse uniquement au(x) destinataire(s) pr=E9vu(s) ou =
=E0 une personne autoris=E9e =E0 le recevoir en son (leur) nom. Il =
pourrait contenir des renseignements confidentiels ou prot=E9g=E9s.  Si =
vous l'avez re=E7u par erreur, nous vous prions d'en informer l'auteur =
dans les meilleurs d=E9lais, de ne pas divulguer son contenu et de le =
supprimer de votre syst=E8me. Merci.


-----Original Message-----
From: Clinton Gormley [mailto:clint@traveljury.com]=20
Sent: August 21, 2007 3:01 PM
To: Dan King
Cc: modperl@perl.apache.org
Subject: Re: Special characters

On Tue, 2007-08-21 at 14:21 -0400, 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 =E9 or =
=E2
> 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 both on Solaris 9. The reason
> I am asking the question here is I am wondering if mod perl does any
> conversion of text that is typed into a text box.=20
>=20


It's not that mod_perl is converting the text.  It's that your program
is NOT converting it.

You are using conflicting character sets.  For instance, maybe data in
your database is stored in UTF8, but on your website you're using
ISO-8859-15.

You need to decode all text coming into your Perl program, and encode it
again on the way out.

Have a look at this tutorial I wrote about using UTF8 with MySQL - may
help.

http://www.perlmonks.org/index.pl?node_id=3D620803

Clint