Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Received-SPF: pass (hermes.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: ?????  +++  problem saving &Euro symbol character to database
    from my JSP form using TC5
Date: Fri, 3 Sep 2004 11:06:56 +0100
Message-ID: <5684A7E6FB10504393A2806C1F4C021003B0E18F@orion.qas.com>
Thread-Topic: ????? +++ problem saving &Euro symbol character to database
    from my JSP form using TC5
Thread-Index: AcSRnLR7znpGcDpKSFGr/XwEpkM5DQAAHLpg
From: "Allistair Crossley" <Allistair.Crossley@QAS.com>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>,
    <ben.bookey@gistec-online.de>

What is your database URL? Are you ensuring that a charset is specified on =
your database connectivity? This charset should be Cp1252 for Windows-1250.=
 Find a row in the database with a euro character and ask yourself how that=
 euro character got there? If it got there using an encoding different from=
 the response encoding then you will get your ?. In order to solve this pro=
blem you need to make sure you have test data correctly encoded to match yo=
ur database encoding. Then work backwards to the UI. Make sure the db URL c=
harset matches the database. Then use a JSP with pageEncoding and charset o=
f utf-8 OR try Cp1252 OR try Windows-1250. I don't think you need to worry =
about changing your DB encoding .. it seems to me that you either have inco=
rrectly encoded data in the database which is throwing you red herrings whe=
n you get the UI encoding right OR your UI is just mal-configured.

> 1. I have a Windows-1250 oracle database, and I am using TC=20
> 5. and jsp/html
> pages
> to perform updates/inserts. Despite using iso-8859-15 in my=20
> jsp/html, the
> client
> is still posting a ? (question mark symbol) instead of a Euro symbol.
> Anybody know what is happening ?
>=20
>=20
> 2. If I do change our product database, from Windows-1250 to=20
> UTF-8, how will
> this affect existing applications I wonder writing to the=20
> database using
> Windows-1250 or iso-8859-1.
> I guess because utf-8 is backward compatable it should not affect the
> existing apps. making
> updates or inserts?
>=20
>=20
> Would appreciate any help !
>=20
> thanks
> BEn
>=20
>=20
>=20
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>=20
>=20


<FONT SIZE=3D1 FACE=3D"VERDANA,ARIAL" COLOR=3DBLUE>=20
-------------------------------------------------------
QAS Ltd.
Developers of QuickAddress Software
<a href=3D"http://www.qas.com">www.qas.com</a>
Registered in England: No 2582055
Registered in Australia: No 082 851 474
-------------------------------------------------------
</FONT>


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org